Power BI real time streaming dataset
HTML-код
- Опубликовано: 7 авг 2024
- Datasets in Power BI can have connection types such as Import, DirectQuery or Live Connection. However, there is also one specific type of dataset which is different. This type of dataset is called Streaming Dataset. A streaming dataset is for a real-time dashboard and comes with various setups and configurations. In this video and article, we'll talk about this type of dataset.
Read more from my blog article here:
radacad.com/power-bi-real-tim... Наука
This video gave me a detailed flow of how live data can be captured, stored, reported, published and refreshed in real time
glad it was helpful
Thanks for making it clear about the real-time steaming dataset.
This is great content. Thanks a lot.
I like and subscribe ! :)
recently there i additional data under add row to dataset , consist od workspace, dataset, table and Payload. what is this payload. do we need to put his. n i try ,my flow, the running flow timeout. why it take so much time?
Thanks a lot! Great overview👍👍
Glad it was helpful!
Can we build real-time dashboard with Google Sheets Source in power bi
?
if in any case there is any change happened in past data how that will be handled
finished watching
Thanks for the video. Question: How can I pull streaming data being saved to a postgreSQL table and show it live in power bi instead of using Grafana?
Hi Cellent. I have the same case. Have your reached a solution?
@@mohamedkorain871 Still looking unfortunately. Thanks anyway. Please let me know if you find a way.
Not sure if this will help you, but we replaced Grafana with Power BI connected to Snowflake using direct query and we set report page to refresh every 5 seconds
@@marcing3364 Thanks for the tip. Polling from postgreSQL to Grafana was fine, so I guess I will try with Snowflake. Too bad that I haven't found a way to show it in Power BI live!
@@cellentmaya1533 I was also struggling with live data streaming, but with direct query it works fine. I tested and data in Power BI was almost at the same time when new data appeared in Snowflake
Nice info 🙂
"Is it possible to receive real-time updates in my Power BI Desktop report directly from the MySQL table without manual refreshing? I'm seeking a solution that doesn't involve publishing the report online. I am running mysql in my laptop only. Thank you."
Hello did you solve, I’m in the same situation
I was trying to replicate this solution and found some bug, I replicate all of the steps, problem is when I open my report in browser and then in other browser tab I will fill new MS Form data will be visible in my PBI report only after manual browser page refresh, I suppose it should be done automatically, is this a bug or maybe I did something wrong ?
I think this is because you have a hybrid dataset now & if you pin the same data in dashboard, it will give you the desired result.
Thnak you
😊👊
Is there a way of implementing the same without power automate?
Yes. you can call the Power BI Rest API with any other applications, C# code, PowerShell, third party applications etc.
@@RADACAD I was trying to replicate this solution and found some bug, I replicate all of the steps, problem is when I open my report in browser and then in other browser tab I will fill new MS Form data will be visible in my PBI report only after manual browser page refresh, I suppose it should be done automatically, is this a bug or maybe I did something wrong ?
Have power bi calls ?
Yes with ADF and ssis