Today it is possible only to have a static data model or direct query. Would really like to have the mainstream refreshable data model available within the embedded offering. Would like to be able to control the refresh via API.
55 Comments
- As of June 2017, The Power BI service and Power BI Embedded came together to offer a single API for embedding your dashboards and reports. This means you now have one API surface, a consistent set of capabilities and access to the latest Power BI features – such as dashboards, gateways and app workspaces – when embedding your content. You can read more about it here- https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-embedding/ For those who work with the Power BI Embedded Workspace Collection solution, we built a migration tool for easier data transition. See more info here- https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-migrate-tool/
- Absolutely critical. The single most important thing (for us) that embedded can do before it's viable for production. We don't use any direct query, all REST api's that need to be refreshed.
- I agree that this is a critical requirement. Since powerbi.com already supports scheduled refreshes, gateway configuration etc. wouldn't it be possible for Embedded to simply reference data sets and reports that have already been published instead of re-importing the PBIX file in Azure?
- SqlJason
Memorable Member
Agreed, very critical - API for refresh on demand and pushing rows to existing datasets is necessary. Current C# SDK contains methods for pushing data, but they fail with Unauthorized status.
- Any ETA?
- A million votes for this.
- About my customer case, this would be an interesting solution, as Direct Query on Azure SQL Database with DAX measures is not efficient at all.
- Just spent 6 weeks developing a PowerBI Embedded solution. Then find out I can't refresh the data!!! I'm stunned. I need to refresh my data hourly. And I have hundreds of reports in a SAAS project. Can we please get some indication if, when this will be fixed? Please.
