Forum Discussion
JonCross
6 years agoFrequent Visitor
live dashboard
I am trying to create a live dashboard for our wall TV in the office. I have managed to design the report and can manually refresh the data in PowerBI desktop but it takes 1 minute to refresh 2000 r...
v-yingjl
Community Support
6 years agoHi JonCross ,
- Push datasets don't contain a formal definition of a data source, so they don't require you to perform a data refresh in Power BI. You refresh them by pushing your data into the dataset through an external service or process, such as Azure Stream Analytics. Power BI still performs cache refreshes for any tiles used on top of a push. You can refer this tutorial for a detailed walkthrough: Stream Analytics and Power BI: A real-time analytics dashboard for streaming data
- Please note that Push Mode has several limitations:
- For Power BI users, refreshing data typically means importing data from the original data sources into a dataset, either based on a refresh schedule or on-demand. Datasets on a Premium capacity with the XMLA endpoint enabled for read-write support unlimited refresh operations when configured programmatically with TMSL or PowerShell.
- You can also trigger an on-demand refresh by selecting Refresh Now in the dataset menu. On-demand refreshes are not included in the refresh limitation. Also note that datasets on a Premium capacity don't impose limitations for API refreshes. If you are interested in building your own refresh solution by using the Power BI REST API, see Datasets - Refresh Dataset.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.