Power Platform Integrations (Read-only)
Power Platform and Dynamics 365 Integrations (Read-only)
Training and Consulting
Instructor Led Training
Dashboard in a Day for Women, by Women
Galleries
Community Connections & How-To Videos
COVID-19 Data Stories Gallery
Themes Gallery
Data Stories Gallery
R Script Showcase
Webinars and Video Gallery
Quick Measures Gallery
2021 MSBizAppsSummit Gallery
2020 MSBizAppsSummit Gallery
2019 MSBizAppsSummit Gallery
Events
Ideas
Custom Visuals Ideas
Issues
Issues
Events
Upcoming Events
Community Blog
Power BI Community Blog
Custom Visuals Community Blog
Community Support
Community Accounts & Registration
Using the Community
Community Feedback
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!
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
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
@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".
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
