Forum Discussion
Power BI and MySQL connectiom
Hello,
I am trying to connect to MySQL Database to get data in Power BI. When I try to do this using get data option, it redirects me to enter server, databse name and credentials. I entered it and also can see Database Tables in the Navigator page. But when I am clicking on any of the table, then the preview keeps on loading for long time and finally no data is displayed from any of the table. what Could be the reason?
And yeah I am using Power BI Free version not the Pro one.
Thanks in advance
4 Replies
- amitchandak
Super User
Anonymous . can you see the load button(right hand side below) even when this load is ongoing? If so; click on that and check if you are able to load the table in power bi.
amitchandak thank you for your suggestion. When I click directly on load button it says as evaluating, loads longer and eventually nothing is loading.
- amitchandak
Anonymous , how big is the data table?
Can you check with a small table.
Also make sure the latest MySQL .net driver is installed - https://dev.mysql.com/downloads/connector/net/
