Forum Discussion
Connect PBI to MySQL
I'm struggling to connect Power Bi to my Database.
I am following all the guides on internet but still...
Here my steps:
- I downloaded and installed a mySql Connector
- On Google Cloud Platform I went to the Overview Page of my project
- On PBI Desktop I went to GetData and Database and selected Mysql Database
- I selected the name of the server (public IP address) and the database name
- I get this error message
I get there might be some missing step but could you please help me?
6 Replies
Hi fabiomanniti ,
Are you trying to connect GCP with power BI? Not sure why you are using a MySQL connection in POwer BI then.
Check the documentation to connect Power BI with GCP here:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-bigquery
Thanks,
Pragati
I also tried this but in this way I see my project but I cannot see my instances where my tables are
Hii fabiomanniti ,
May be you need tocheck your permissions and access rights for your tables which reside in BigQuery.
Thanks,
Pragati
If I go on the main page of google platform I get this:
After I go on SQL I can see my instances
and only then I can see my tables
Hi, fabiomanniti
Confirm again whether the IP address is the latest and entered correctly.
Best Regards,
Community Support Team _ JaneyHi, fabiomanniti
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.Best Regards,Community Support Team _ Janey
