Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Getting Live data from MySQL

Hi , I have a MYSQL as Datasource from which I pull data created some custom calculated column and now implemented it using Power Bi visuals. Now I am facing issue in seeing the Live data. To see ...
Gateways
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous,

 

As the MySQL is on-premise data source, after publish the report to service, we need to configure the dataset to use on-premises data gateway. You can install the on-premises data gateway follow this article: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem. Then create a MySQL data source under gateway and configure the dataset use the gateway follow this: https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-scheduled-refresh

 

You can set the Schedule Refresh for the dataset, also you can click Refresh Now to refresh manually. After the dataset is refreshed, we can open the report and data are updated. But if we open the report before dataset is refreshed, we need to click Refresh inside of the report or refresh the browser page to see the updated data. 

 

Best Regards,
Qiuyun Yu 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Qiuyun,

I have SQL server 2008 R2 version and I am unable to setup Enterprise gateway for this. Do I require newer version os SQL server or 2008 should be compatible for gateway. Objective is to schedule a refresh of my data.

Thanks,