PowerBI real time data without Stream Analytics

1
votes

How can I add live data to a PowerBI dashboard when I'm not using Azure Stream Analytics to passthrough messages? The refresh rates by default do not seem to support this.

3
powerbiazure-stream-analytics
You can use Direct Query Dashboard to connect to database, it's always live data – cuongle
@CuongLe that's a good point. If this person is not looking for a real-time animating tile then connecting to a Direct Connect source may be all they need. sqlchick.com/entries/2015/9/4/… – GregGalloway

3 Answers

0
votes

Stream Analytics output to Power BI is just a layer on top of this Add Rows Power BI REST API plus a few related APIs like creating a dataset. You could do that yourself in your own code without Stream Analytics as shown in these samples. This still achieves the real-time animating tiles in Power BI.

-1
votes

Only when you use Azure stream analytics, your Power BI dashboard is auto-refresh

-1
votes

The alternative for Stream Analytics would be to use the PowerBI API's to add row to a dataset.

Take a look at this sample to get started

Note: In the Free tier you can update 10k rows per hour.