Forum Discussion
Dataset refresh takes too long
The Power BI Service is not dedicating resources exclusively to your refreshes. They can sometimes be queued, and other times run slower.
Requesting new refreshes while an existing refresh is in progress is considered bad practice and should be avoided.
Does your webpage not provide the real time reporting that you seem to require? What's the value add of Power BI?
Hi lbendlin, thanks for the reply.
lbendlin wrote:The Power BI Service is not dedicating resources exclusively to your refreshes. They can sometimes be queued, and other times run slower.
Does this mean there's nothing I can do to improve the Dataset Refresh time other than improve the Data Source load time?
lbendlin wrote:Does your webpage not provide the real time reporting that you seem to require? What's the value add of Power BI?
No, the webpage only serves raw JSON data. Power BI adds value in the form of auto-refreshing visuals representing my data.
Thanks again!
Auto refreshing is something you usually do with Streaming or Push Datasets, or with Dashboards. Have you considered pushing the JSON into a Hybrid Streaming Dataset?
I can't find much information about Hybrid Streaming Datasets. Do you have any documentation or resources which could help? It this related to "Real-time streaming" which is being retired next week?
https://powerbi.microsoft.com/en-us/blog/announcing-the-retirement-of-real-time-streaming-in-power-bi/Shannon Lindsay wrote:
Beginning October 31st, 2024
Creation of new real time semantic models will no longer be supportedIncludes Push semantic model, Streaming semantic model, PubNub streaming semantic model, Streaming data tileIs there another type of streaming that will be supported after 2024-10-31?
Thank you,
That's a (rather unwelcome) surprise, especially with the level of immaturity around the Kusto based solutions. I would recommend you quickly create a couple of streaming datasets so you can use them for the next three years, with the hope that by then Kusto is a viable alternative.