Powerbi dashboard vs Powerbi report in real-time streaming datasets

[harryli]

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.

[Hariharan_R · Accepted solution]

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