Automati Refresh

[Kaskazi_Network]

Hi,

I'm working on reports that read data from a MySQL database (Which is updating every minute). My reports also need to be real time, so I'm looking for a way whereby the desktop can refresh data and adjust the reports automatically and publishes the upto date report on the powerbi service.

Is this achievable? If so, Kindly advise how can I go about it.

Thanks.

[v-deddai1-msft · Accepted solution]

Hi @Kaskazi_Network ,

Mysql doesn't support direct query mode, so you can't use automatic page refresh for it.

You can create streaming dataset in Power BI Service and use Rest API to push data from MySQL database to streaming dataset. This way, you can get real time data from MySQL database .  Please refer to the similar post: https://community.powerbi.com/t5/Developer/Real-time-connection-to-MySQL-database/td-p/206136

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

@Kaskazi_Network , It supported for direct query mode. And I doubt mysql is supported for direct query

[negi007]

@Kaskazi_Network  I suggest you to go through below links to get better understanding on the data refresh.

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

https://docs.microsoft.com/en-us/power-bi/report-server/configure-scheduled-refresh

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-local-drive

[Anonymous]

Hi, 

when you connect to your data source, select "Direct query mode" instead of "Import mode". This will create a dynamic link to your data source. 

The transformations in PowerQuery are reduced, and you will not see the data in the data model. But you can use the data as you´re used to to create visuals. 

There´s no need for refreshes anymore, and you can even set a periodic page refresh (on the report page itself) to pull most recent data into the visual.

Alexander

If this solves your problem, please accept as solution.  

[Mariusz]

Hi @Kaskazi_Network 

Please refer to the below.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn