cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

MySQL OLE DB or ODBC errors during refresh

Hello,

 

I have these errors when trying to refresh the dataset in my project (power bi desktop)

 Capture.PNGCapture1.PNG

The errors interchange between the tables when I hit refresh again. I haven't refreshed the data since 3rd of September this year and the major change that I can recall is installing the new September patch, could this be the problem?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: MySQL OLE DB or ODBC errors during refresh

Hi henriquesilveir,

 

This is a duplicated post, I didn't know how to delete it Smiley Very Happy. But I added the post here: solution for me. It was basically alocating more resources to powerbi and removing paralel loading of tables. It might be some of what you've mentioned. But maybe power bi isn't showing correct errors / exceptions on this particular case.

View solution in original post

2 REPLIES 2
Highlighted
Resolver IV
Resolver IV

Re: MySQL OLE DB or ODBC errors during refresh

Hello, @Anonymous , where are these sources?  Localhost? are you connect in the same host? have any gateway installed there?

 

When you get some troubleshotting refreshing your data  in this article you can see all troubleshotting scenarios https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios , if your problem till, please try to refresh into power query editor of PBI and send more details about the issue, ok? 

 

I Hope the article help you ! 

Highlighted
Anonymous
Not applicable

Re: MySQL OLE DB or ODBC errors during refresh

Hi henriquesilveir,

 

This is a duplicated post, I didn't know how to delete it Smiley Very Happy. But I added the post here: solution for me. It was basically alocating more resources to powerbi and removing paralel loading of tables. It might be some of what you've mentioned. But maybe power bi isn't showing correct errors / exceptions on this particular case.

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors