Azure Analysis Service or Azure Stream Analytics

[jitpbi]

Hi,

I needed the recommendations from the experts to overcome the no. of refresh limitation in my Power BI reports. I have Power BI premium license and Cosmos db is the datasource but there is a limitations of 48 times to refresh the reports.

The requirement is to show the data on visuals at real time in the reports.

There are 2 options which i got to know Azure Analysis Service and Azure Stream Analytics to show the data on visuals on real time. As i got to know only a very limited set of Power BI visuals (Card, Line chart, Clustered bar chart, Clustered column chart and Gauge) supports streaming dataset and it does not support filter also. 

I would like to know more about these two and which one should be preferred. I will need all types of visuals and filter option for my reports.

Thanks

[v-kelly-msft · Accepted solution]

Hi @jitpbi ,

If you wanna show the data on visuals at real time,you should choose  direct query or live connection as the dataset connection mode or you may store the dataset on a cloud service,such as onedrive,sharepoint,etc.

Below is the related reference.

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!