Forum Discussion
Power BI Web can't get dataset from MySQL
I have an Pro Account, and try to use PowerBI Gateway Enterprise to get data from MySQL server.
And the result is:
The Connection is successfull, but the Dataset is not shown; and I don't knows what went wrong.
Thanks all for helping me!
Regards,
thinhnguyen The screen shot is really small, and won't blow up for me, but it looks like you've added you MySQL database as a data source in the Gateway in the Service. That is step 1, and won't by default create a dataset in the Service. A Data Source is where the data comes from, DataSet is data from a data source you are uploading.
What you've done is create a connection in your gateway for accessing that data source. Now the users that you have added to that data source can upload datasets using that data source.
So, step 2 - is to create a report in the Power BI Desktop (because you can't directly connect from the service to MySQL) and publish that dataset to the Service. Then you will see a new dataset in your list.
4 Replies
Hi All,
Please show me how can I summit a ticket to clear this problem!
I have a Pro account, but can't find any place to raise ticket.
Thanks you for your help!
thinhnguyen The screen shot is really small, and won't blow up for me, but it looks like you've added you MySQL database as a data source in the Gateway in the Service. That is step 1, and won't by default create a dataset in the Service. A Data Source is where the data comes from, DataSet is data from a data source you are uploading.
What you've done is create a connection in your gateway for accessing that data source. Now the users that you have added to that data source can upload datasets using that data source.
So, step 2 - is to create a report in the Power BI Desktop (because you can't directly connect from the service to MySQL) and publish that dataset to the Service. Then you will see a new dataset in your list.
Anonymous Thanks you so much!
As you wrote, Power BI Web can't auto reload when data on MySQL server change?
