Forum Discussion
Unable to get data from MySQL Server. Power Query works fine but Power BI fails to get data.
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...
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.
- 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.
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...