Forum Discussion

Kaskazi_Network's avatar
Kaskazi_Network
Helper I
6 years ago
Solved

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 ...
Need Help
Tips and Tricks
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    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

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
6 years ago

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