Streaming dataset with SQL Server

[Anonymous]

Hello everyone!

I was looking at this article looking for some solutions to real time data:

https://sqlitybi.com/streaming-data-from-sql-server-to-power-bi-using-powershell/?doing_wp_cron=1591...

But my question is this: Could I setup a SQL aggregation query in Powershell that looks like this(it does not have a date field), and get this same updated table in PBI Service every few seconds with data streams?

Its basically a real-time sum of the calls by line and call type.

CallType	Line1	Line2	Line3
A	2	0	3
B	1	1	4

Thanks!

[v-alq-msft]

Hi, @Anonymous 

You may try to use power shell to connect to database and retrieve your data with a power shell timed loop . Then you can create a  Real-time streaming in Power BI to see if it helps.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.