How to show real time data from mysql

Question

Hi,&nbsp;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.&nbsp;Please let me know if there is any way how I can proceed

anonymous · Answer

Hi lavina03,&nbsp;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. &nbsp;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&nbsp;Notice: you should setting the gateway before using scheduled refresh: On-premises data gateway.&nbsp;Regards,Xiaoxin Sheng&nbsp;

dkay84_powerbi · Answer

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

Forum Discussion

Related content

Mirroring from on-premise PostgreSQL and MySQL sources

Showing null instead of real value

MySQL connector doesn't show new table on schema

Real-Time Datasources for Real-Time Intelligence.

Real time connection to MySQL database