Forum Discussion
Helper IIPowerbi dashboard vs Powerbi report in real-time streaming datasets
Hi, I can do the real-time streaming dataset to the powerbi dashboard, but it is difficult to do the real-time in powerbi report.
May I ask any guidelines to do the real-time data visualization with sql data, thanks.
Hi,
When you specify real-time data visualization with sql data, i hope you are getting data in SQL DB very frequently and you want to show that in your Power BI report immediately.
You need to use Direct Query mode option for which table you are getting data more frequenctly. You can build a visuals using that table and setup a automatic page refresh. You will get immediate data to Power BI.
Ref - https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh
Thanks
Hari
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My Linkedin
1 Reply
- Hariharan_R
Solution Sage
Hi,
When you specify real-time data visualization with sql data, i hope you are getting data in SQL DB very frequently and you want to show that in your Power BI report immediately.
You need to use Direct Query mode option for which table you are getting data more frequenctly. You can build a visuals using that table and setup a automatic page refresh. You will get immediate data to Power BI.
Ref - https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh
Thanks
Hari
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My Linkedin