One or more rows contain values violating non-null, unique, or foreign-key constraints

[donnaolmeca]

I am trying to connect Power BI to my local MySQL DB.

I am geeting the following 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.'"

For testing purposes I created a simple table with one column only, 1-15 numerical values, no dupliactes, no-nulls - also table settings have been set to: non-null & unique, no fregin-key.

Not sure what is the issue here. Please advise.

[WGordon]

I'm now having this issue as well. Did anyone find the solution?

[Anonymous]

@donnaolmeca,

I have no issues when connecting to local MySQL database in Power BI Desktop. Do you get errors when you connect to MySQL database from other applications such as Excel?

Could you please post Create statement and Insert Statement of this table here so that I can test?

Regards,
Lydia

[Anonymous]

Hi,

This is happening for me as well. I would like to give more color on this topic:

- PBI Desktop version: Nov 2018.

- MySQL 8.0.13. Default values for collation and charset.

I did an A/B test. I have 2 MySQL instances. For the MySQL5.7 instance, I'm able to connect to this without error.

The other instance MySQL 8.0.13 throws the below error when I'm attempting to connect.
"DataSource.Error: 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.'"

This happens when trying to Get Data.

The table does not seem to matter. Here's a test table anyway

CREATE TABLE `tmp_test_pbi` (
`col_a` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Testing PBI connectivity issue.';

INSERT INTO tmp_test_pbi VALUES('a'), ('b'), ('c')

[Roberto456]

I having this issue as well