Forum Discussion
Automati Refresh
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.
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
5 Replies
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.
LinkedInHi,
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.
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
Kaskazi_Network , It supported for direct query mode. And I doubt mysql is supported for direct query
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
