Forum Discussion
Real time Analysis From a SQL Database
Hi DebbieE ,
I haven't done much research on this.
Just to provide a reference, consider using streaming datasets, like using PowerShell to push data to a Power BI Push Dataset from a SQL Server data source. For specific operations, you can refer to this blog: https://www.blue-granite.com/blog/power-bi-streaming-datasets-for-more-than-iot.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Fantastic
I will have a look at this and see if I can get something working. However one of this isues, which I dont think is covered in this article is that I dont want them getting data from a transactional system
What is the best way to deal with this before its addded to a push data set. I imagine my users are still going to say, why bother doing all that when we can just direct query the transactional system