Forum Discussion
Power BI Web can't get dataset from MySQL
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.
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?
thinhnguyen You can refresh the dataset after you publish it.
Order of operations.
1) Set up Gateway (you did)
2) Create data source in gateway that matches (you did - the MySQL db)
3) Create a dataset by using the Power BI Desktop, connecting to the MySQL db and creating reports. Publish that to the Service
4) A Dataset will appear in the Service with your PBIX file name - the connection to MySQL is recognized by the Gateway on the back end
5) Click the "..." next to the dataset name and schedule refresh
6) This will allow you to schedule a refresh of data up to 8x a day (this refresh uses the Gateway you've set up)
You can also refresh at any time by clicking "Refresh Now" in the same area as #6