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

Figured it out, thank you.

Figured it out, thank you.

13 REPLIES 13
Highlighted
Microsoft
Microsoft

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

I believe the recommendations made at your other thread are correct.  Try to trim/clean the data and set to all upper or lower case (if applicable) before doing a remove duplicates step.  You may also be able to improve the uniqueness of your key if you add an index and merge before removing dups, but again, this will depend on your exact scenario and data.

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.

Well in fact I have over 11 "Imports" i need to figure out the relationships on.. and right now I am just trying with the two.. I have managed to create a relationship between these 2, but whenever I drag a column in from both of em

Highlighted
Microsoft
Microsoft

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

If you are willing/able to share your pbix file with the community, we can take a look for you without paying for a skype session.

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.

Really prefer not to share it with the entire world and the DB I look up against is just a backup on my own machine, so you wont be able to use the SQL database either so unsure how much the pbix file will help you if you cant boot it up against any database?

Anyways really willing to pay 50-100$ to get these relationships fixed, depending on how long time it take over skype.

Skype: Snaske2

Highlighted
Microsoft
Microsoft

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

So if you are using Import mode (vs. Direct Query) which you said you were, then the imported data is stored in the data model that comes with the PBIX.  However, I understand that you don't want to share the data.  Is it possible to create some obfuscated or dummy data that at least matches the structure and syntax?

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.

Hmm give me a minute, ill try.

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.

Nah, it's to hard obfuscating all the data, even if I use a tool like SQL Data Generator it wont create the same issue as the same values / duplicates might not show up.. just tried=/ really think a skype session with payment will be the best

Highlighted
Community Champion
Community Champion

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

@Shamatix

 

To the tables in the screenshot, you need to change the relationship from Single to Both.

 

 




Lima - Peru
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.

By putting it to both like below right? I have already tried thathttp://i.imgur.com/sqEn7T8.png

 

Then I get this:

And my relation sh

 

Once again if any wants to earn some money... and help me out =/ feel free to add me on skype: Snaske2

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors