Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone!
I was looking at this article looking for some solutions to real time data:
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!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.