Unable to get data from MySQL Server. Power Query works fine but Power BI fails to get data.

[VictorBatista]

Hi, I have a server machine that I want to use as gateway for my companies Power BI's, but we are having problems when trying to get data from MySQL Server Databases. After installing the gateway and failing to set up the paths, I went to Power BI desktop to see if everything was working properly.

We are normally getting data from AWS Athena Lakes and files in out companies intranet, but with MySQL databases we are being able to read the data in Power Query, but when we close and apply and Power BI tries to read the data we get an Athentication Error message like below.

We already checked if the machine's firewall or our companies network firewall are blocking something, but according to the netsec teams, thats not the issue.

We also checked if there are any problems related to ports, but nothing poiting out as well.

Can you help me?

[v-rongtiep-msft]

Hi @VictorBatista ,

When i renamed the excel file, I got the same error as below. 

I'd like to suggest you check if the file is in the path and the file name is matched with that in Power Query.

I have also found a similar post, please refer to it to see if it helps you.

https://community.powerbi.com/t5/Desktop/Loading-blocked-by-failures-with-other-queries-for-local-fi...

https://community.powerbi.com/t5/Desktop/Data-source-change-error-quot-Loading-blocked-by-failures-w...

• Power Query Editor -> Data source settings -> Change data source
• Ensure you have access permissions to it. 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VictorBatista]

Hey, I'm getting data from MySQL databases, not files, so their names as static, no one is able to change it. And also, my Power Query reads the data just fine, but Power BI is the one unable to read it. So it is not a datasource path problem...

[lbendlin]

What's your gateweay version?  Gateways after 66.8 broke the MySQL connector in cases where the TLS levels don't match.

[VictorBatista]

Hey, Ibendlin. I'll check te gateway version, but I don't believe it is related to that, because my Power BI Desktop is also unable to get the data. The odd thing about my problem is that Power Query reads the data just fine and Power BI is the one unable to read it...