cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Re: I want to BUY help for a skype session on how to create all my many to many relationship tables.

Still looking to buy some help ... preferable a skype session =/

Highlighted
Helper III
Helper III

Re: I want to BUY help for a skype session on how to create all my many to many relationship tables.

I have had a similar issue where I had relatinships set up across several tables but there was no relation between others. In some instances I have found this doesn't matter, but in others I have had the same problem with visulisations not working.

 

One of the things I tried where I need just one field from anohter table was to add a new column to a second table that simple looked up the value from the first table. Then I had tables 2 and 3 with reltationships that worked and i would work around getting the data from the 1st table. This worked well for me because it was only one field that I needed to duplicate. It might be more problematic if there are lots of fields you are hoping to 'duplicate'.

 

If there a link between your tables 1 and 3 that you could include or superficially generate by the using the above method in some way? Like I say, I have found it depends on the fields you are looking at. Sometimes I had no issue and other times I had to work around it by adding in a field that would replicate what I was after.

I hope this helps.

Highlighted
Helper III
Helper III

Re: I want to BUY help for a skype session on how to create all my many to many relationship tables.

i've just had a lok at your other thread - have you figured out which field is causing the problem?

 

I would create a table with a field from table 1 and then gradually adding in more fields from the other table. If you find some fields can be added that is probably good news at least, or are you finding that you get problems as soon as you add fields from the 2nd table?

Highlighted
Post Patron
Post Patron

Re: I want to BUY help for a skype session on how to create all my many to many relationship tables.

 No I have sadly not =/ By any chance I may share you my screen on skype as I am fairly new in Power Bi and perhaps you could show me?

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors