Forum Discussion
Power BI embedded supports data refresh
I was waiting for the release of this feature and DirectQuery option was slow. Finally, created an automation solution(C#) that opens the pbix file, click the refresh button. Once refresh is completed, it saves it and close Power BI desktop. Import the pbix to PowerBI embedded.
Anybody who knows if there is any update to this?
I need to pull data from API in the pbix file and need to show data as real-time as possible. This allows for 48 times refresh in a day (every 30 mins) even with Power BI Premium license.
If I go with Power BI embedded approach can I bring it down to 5 mins by any chance? Appreciate any pointers.
But aren't programmatic refreshes triggered through the API constrained by the workspace capacity anyway (i.e. up to 8x or 48x per day)? It sounds like they are in the documentation:
https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/
That's right otravers.
Refreshes are constrained to 8 or 48 times per day based on the acquired capacity. If you exceed this limit, you get an exception "Number of refresh requests in last 24 hours exceeded limit".
To add some more on this topic every refresh consumes part of the acquired capacity. So, you may face situations that a refresh (even for a small dataset) takes a long time waiting for some capacity to be assigned to it.
A feature that allow incremental refreshes has already started and it would be nice addition to the refresh toolkit.
Hope this add to the conversation.
Regards,
Thanos
