Forum Discussion
Helper IReal time connection to MySQL database
oitp,
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 . For more details, please check iAm3G's reply in the following similar thread.
https://community.powerbi.com/t5/Developer/Real-time-connection-to-MySQL-database/td-p/206136
Regards,
Lydia
Helper IAnonymousthank you. After reading this I still have a hard time grasping the steps to push my data from MySQL through Rest API. Do I use my gateway or is it all done from the web?
If you have any other tips I am all ears!
oitp,
Gateway is not required. You can push data from MySQL to streaming dataset using PHP and cURL following iAm3G's suggestion.
Regards,
Lydia
- oitp
OK. I ended up using a different way to display my data which was more suitable. But thanks for the tips :)
please can you show me your steps .. i'm facing the same problem
ThanksCan you please help me with the same? I am facing the same issue
