cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
v5out
New Member

Power BI Desktop crashes frequently when I Manage Relationships

I've connected PBD to a local MySQL database and brought in 7 tables with a total of 100 columns. When I try to Manage Relationships (PBD gets them 100% wrong) PBD crashes most of the time. There's nothing unusal about the data or the foreign keys between tables, they follow the standard RoR convention, e.g. a "user_id" integer key in a table points to the user record with that id.

 

Any known fix or workaround? Anybody else have this problem?

 

I'd like to use PBD instead of Qlik or Tableau because the pricing is great but it's not reliable with the MySQL data I'm using.

 

Thanks,

John

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

First, make sure you are on the latest build of Power BI Desktop, I have worked with it with MySQL and have not seen these issues.

 

Second, go to File | Options and settings | Options

 

Under CURRENT FILE

 

You can uncheck the options to automatically try to detect the data sources and import relationships from data source. Might solve your issue and you can just manually create the correct relationships.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

First, make sure you are on the latest build of Power BI Desktop, I have worked with it with MySQL and have not seen these issues.

 

Second, go to File | Options and settings | Options

 

Under CURRENT FILE

 

You can uncheck the options to automatically try to detect the data sources and import relationships from data source. Might solve your issue and you can just manually create the correct relationships.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

I've had the same issue with it constantly crashing when selecting/unselecting checkboxes in "Manage relationships". Tried turning off auto-detect but it still persists. Is it the complexity of my data that's causing this?

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors