live dashboard

[JonCross]

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 rows. I am pulling data in from an API call.  Their api isnt the best and has static pagination.  To overcome this I have made 20 x queries at 100 records per page and then combined them into a single query.  I then based the report around this query.  Is there a better way to do get the data in?  I also want to user PowerBI online to show the report on the TV but you can only refresh 8 times a day, this is not live!  I did look at a streaming push data set but can't seem to get the data from the api call to the push dataset.  Can anyone help as I am still new to PowerBI?

Thanks in advance

[v-yingjl]

Hi @JonCross ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,
Yingjie Li

[v-yingjl]

Hi @JonCross ,

1. 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 
2. Please note that Push Mode has several limitations:
3. 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.
4. 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.