cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

Can no longer connect to MySQL Database (Cloud)

Hello all.

 

Something strange has happened to my connection to our companies MYSQL database.

 

Just starting a new document and trying to connect gives me this error:

 

Details: "An error happened while reading data from the provider: 'Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.'"

 

Does anyone know what this means?

 

 

7 REPLIES 7
Highlighted
Community Support
Community Support

Re: Can no longer connect to MySQL Database (Cloud)

Hi @Roberto456,

Did this issue appear on a new pbix report or after the refresh on existing power bi reports? It seems like your data structure has changed on your datasource side so that it did not match the data table design rules.

Can you please provide more detailed information to help us clarify your scenario?

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Super User IX
Super User IX

Re: Can no longer connect to MySQL Database (Cloud)

@Roberto456 , Make sure you latest driver

https://www.edureka.co/community/41704/how-to-connect-to-mysql-database-from-power-bi



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Resolver I
Resolver I

Re: Can no longer connect to MySQL Database (Cloud)

This happens when i try refreshing on exsiting report and when i just try connecting at all on a new report.

 

Im not sure if the mysql connector has drivers?

 

there seems to be only one version?

Highlighted
Helper V
Helper V

Re: Can no longer connect to MySQL Database (Cloud)

@Roberto456  is this only happening in Power BI, or is this occuring outside of Power BI as well?

Highlighted
Resolver I
Resolver I

Re: Can no longer connect to MySQL Database (Cloud)

This is only happening in Power BI.

 

When i log into the DB through workbench , its fine.

Highlighted
Helper V
Helper V

Re: Can no longer connect to MySQL Database (Cloud)

Has anything changed with your Power BI Desktop, Gateway, or MySql drivers?

 

There are two types of drivers that work with Power BI. The ODBC and Net drivers. Do you know which one you have and the version you have?

 

Net Driver link: https://dev.mysql.com/downloads/connector/net/

ODBC Link: https://dev.mysql.com/downloads/connector/odbc/

 

Post referencing drivers: https://community.powerbi.com/t5/Power-Query/Trying-to-connect-to-MY-SQL-from-Power-BI/td-p/195060


Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Highlighted
Resolver I
Resolver I

Re: Can no longer connect to MySQL Database (Cloud)

i have downloaded both.

 

connector.JPG

 

connector.JPG1

 

This is the Error:

 

connector.JPG

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

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.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors