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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.