Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi, is it possible to get real time data from a MySQL database? I would like an update of my reports/dashboards with fresh data at least every 5 min and all options I can see is for me to set this manually, which would be a handful.
I could probably get along with refreshing every 5 min during working hours (8 am - 5 pm).
I use Power BI Pro and I have an gateway installed on one of my local servers with access to the MySQL database.
Any help would be much appreciated 🙂
Solved! Go to Solution.
@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
I have a MySQL database where I want to create the real time report just like time series charts. Can anybody helps me with the steps.
Thanks.
@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
@v-yuezhe-msftthank 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
OK. I ended up using a different way to display my data which was more suitable. But thanks for the tips 🙂
Can you please help me with the same? I am facing the same issue
please can you show me your steps .. i'm facing the same problem
Thanks
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
7 | |
6 |