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?
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?
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?
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/
Post referencing drivers: https://community.powerbi.com/t5/Power-Query/Trying-to-connect-to-MY-SQL-from-Power-BI/td-p/195060
Find out who's part of the program this season, and welcome the new Super Users.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Learn about the exciting things that happened in July.
All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.
Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.