Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How can I ensure that Power BI reports published in Power BI Embedded shows the latest data via refresh? How would it work if a report is doing data import or DirectQuery?
Regards,
P.
Solved! Go to Solution.
As far as I know, three ways to refresh the data in Power BI Embedded.
Well, 7 years after the fact is better than never, here's an updated answer for anyone who reads this:
This all comes down to the Power BI JavaScript SDK. Specifically, there is a method that is used to refresh a Power BI report, and I want to discuss this for a moment:
.Refresh()
This JavaScript method behaves differently depending on what type of storage mode your Power BI report is using, either Import Mode or Direct Query.
Import Mode
If your report is using Import Mode, then you still have to configure scheduled refreshes.
Keep in mind that:
Direct Query
There is no refresh limitation with Direct Query, and Microsoft even has Automatic Page Refresh to use with DQ nowadays. However, there is hardly any refresh restriction for DQ when you use this JavaScript SDK that Microsoft has on GitHub.
Summary
Here's How .Refresh() Works For Each Storage Type:
In both cases, you can call the .Refresh() method from the JavaScript SDK up to every 15 seconds if you desire - so very close to realtime.
This is how .Refresh() works in my custom Power BI digital signage app, Displagent. It supports both storage modes and uses that Power BI JavaScript SDK method to force visuals to autoupdate themselves. This is the only way that someone can force visuals to autoupdate themselves when you are using Import Mode.
This is not solved.
DirectQuery has a lot of limitations. A PBIX that has imported data can be uploaded to app.powerbi.com and a scheduled refresh ca nbe set up by providing DB connection credentials. This is a must-have for the embedded option. The idea of uploading a new file every few hours is ridiculous and not a solution in the real world.
Is there a feature request out there somewhere for this?
Cheers,
Paul
@ddaas wrote:
This is not solved.
DirectQuery has a lot of limitations. A PBIX that has imported data can be uploaded to app.powerbi.com and a scheduled refresh ca nbe set up by providing DB connection credentials. This is a must-have for the embedded option. The idea of uploading a new file every few hours is ridiculous and not a solution in the real world.
Is there a feature request out there somewhere for this?
Cheers,
Paul
Feature request for uploading a new file every few hours, Power BI Designer API, with this pbix can be created and refreshed programmable and then sent to Power BI Embedded workspace without human intervention.
Another feature request for gateway in Power BI Embedded, with gateways it will be possible to do the same refresh as in Power BI Service.
Though it sounds a little ridiculous, if Power BI Embedded is preferred and direct query is not acceptable, that is the only approach. Otherwise use Power BI REST API instead, the pbix is published to Power BI Service and the imported dataset can be scheduled to refresh.
I think I've heard that Microsoft is working on scheduled refreshes of "Import"-mode PBIX files, in Azure workspaces, for Power BI Embedded.
Also, there is this idea, where I added the following comment...
I'd like to expand on this idea, and give it my votes:
1. I would like to be able to use the UI in the Azure Portal to create/edit/delete Workspaces (and give them friendly names), just like I can do with the Workspace Collections that contain them.
2. Then, I would like to use the UI in the Azure Portal to import/delete/manage the PBIX files (Reports) that are consumed by Power BI Embedded.
And then, for bonus...once such scheduled refreshes are supported...I would like to use the UI in the Azure Portal to schedule refreshes of those PBIX files (for "Import"-type PBIX files, of course -- the ones that do not do "Direct Query"), similar to how I can schedule refreshes in the Power BI Service.
This is not solved.
DirectQuery has a lot of limitations. A PBIX that has imported data can be uploaded to app.powerbi.com and a scheduled refresh ca nbe set up by providing DB connection credentials. This is a must-have for the embedded option. The idea of uploading a new file every few hours is ridiculous and not a solution in the real world.
Is there a feature request out there somewhere for this?
Cheers,
Paul
As far as I know, three ways to refresh the data in Power BI Embedded.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
29 | |
3 | |
3 | |
2 | |
2 |