Forum Discussion
Community ChampionReal time Analysis From a SQL Database
Community SupportHi 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.
Community ChampionIm absolutely lost as soon as the article gets to the bit about Powershell.
I have no idea where to do this bit. It gets very high level at this point and I would need more step by step guidance on what Im trying to do.
are there any articles on line with more detailed explanations on this?
- Icey
Hi DebbieE ,
Hope these documents and videos could help you:
Create a Power BI streaming dataset for real-time dashboards;
Streaming Data from SQL Server to Power BI using PowerShell;
Stream Dataset for local SQL Server Database Query.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- DebbieE
Fantastic,
Guy in a cube is always great, Its a nice starter. The middle one is really helpful but doesnt explain the actual connecing up on the power shell script into the Real time data sets.
Ive not read the third one yet but Im getting closer. Ill post when I have had chance to do more. Thank you so much