Forum Discussion

lavina03's avatar
lavina03
Helper I
9 years ago

How to show real time data from mysql

Hi,

 

I have some mysql queries where I get the count of jobs. I need to know if its possible to show this count in real time on dashboard.

 

Please let me know if there is any way how I can proceed

Need Help
Tips and Tricks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi lavina03,

     

    Based on test, power bi desktop use import mode to connect MySQL database, you need to manual refresh the datasource to get the newest data.

     

    In addition, if you publish the pbix file to service, you can use scheduled refresh to auto refresh the data, for detail information you can refer to below link:

    Data refresh in Power BI

     

    Notice: you should setting the gateway before using scheduled refresh: On-premises data gateway.

     

    Regards,

    Xiaoxin Sheng

     

  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    Microsoft Employee
    9 years ago

    If you go to edx.org, there is a free course from Microsoft called "Intelligent Apps."  Within the course there is a module on real time analytics using PowerBI for visualization.  It might be worth a watch for your situation, although it will not provide a perfect solution (you will have to do some customization).