New ErrorCode=-2147467259

[Anonymous]

Refreshing has started to fail for a query after previously working. The error message in power query is:

DataSource.Error: MySQL: Fatal error encountered during data read.
Details:
DataSourceKind=MySql
DataSourcePath=[server name];[database name]
Message=Fatal error encountered during data read.
ErrorCode=-2147467259

This only happens if the table is merged with another table from the same database. Each on their own work fine, and removing the merge allows the refresh.

The Edit Permissions page for the database is set to Organizational, and the Encrypted connection is unselected. There are also 10 Native Queries for the source if that is relevant.

Does anyone have insight into what might be causing the issue, or should I focus on a work around?

Thank you so much!

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

You can check the similar solved case:Solved: OLE DB or ODBC error: [DataSource.Error] MySQL: Fa... - Microsoft Power BI Community

This is a solution: Clearing all data source permissions (File-->Options and Settings --> Data Source Settings --> clear each data source permission). Hope it helps.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

[james11209]

Hi, I stumbled upon the same error with this thread, the thing is I can perform left join and right join with my table, but when it comes to inner join it always pop this error code, can I have an optional solution for this please?

[Anonymous]

Didn't work

[Anonymous]

This worked, thank you for the help!

[Anonymous]

모든 자격증명을 지운 후 자격증명을 새로 입력했지만 결과가 변하지 않았습니다.

이럴때는 어떻게 해야할까요 ? 내부 네트워크를 사용중이라 Gateway 문제도 아닙니다 

[Greg_Deckler]

@Anonymous You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".