Forum Discussion
Embedding Paginated Report with a Power BI Dataset
Hello. I am trying to embed a paginated report in my web application that uses a Power BI Dataset as its datasource. I can get the embed token, but when rendering it, I am getting this error:
The dataset being used and the paginated report are on the same Power BI workspace.
Any help will be appreciated.
24 Replies
We are marching towards having this available by Jan in production
Hope this helps
Aviv
Please give it another week
Thanks
Aviv
Ah, I am also trying to do the same thing.
1. Able to build, and view the report went built against a PBI dataset
2. Able to publish the Paginated Report to PBI Workspace - Also works fine, and renders, views, etc the PBI dataset.
3. When embedding, the token etc is generated fine; However, the DYNAMIC DataBinding V2 token generation methods do NOT work.
4. When loading into embedded application, same error as yours. The is BS for sure.
5. When I use the token from the Paginated sample, all embeddes fine.
6. Clearly something not tested, broken or such thing with Embedded PBI datasets.
7. The other obvious issue is the ability to dynamically bind dataset to PowerBI paginated reports.
8. This dynamic binding is really the only way to make SaaS multi-tenant applications with 10s of thousands tenants viable - ie same report, many different dynamic datasets. -
chrisfin Help ?
Thanks Chris,
This dynamic data set construction is actually a really cool way to build dataset. We use the PushDS API (which I wish was richer). But scenarios can be very interesting, such as combining 1st party data and 3rd party data from say their APIs, doing the mashup in code C# to ensure data integrity, and then presenting a unified model to PowerBI (and hopefully Paginated soon).
The other obvious feature is "respecting the model" in Paginated. But I guess this is the legacy vs the future issue.
If you need some early beta/preview testing let me know.
- phil
Hello.
Any update on this issue? We are having the same problem and looking forward for the solution.
Embedding paginated reports based on Power BI shared datasets in the "App Owns Data" scenario is really important thing in our bisness application.
Any ETA of fixing it and getting rid of this annoying limitation?
Currently we are getting the error below while rendering embedded paginated report:
Code: "RSWorkloadError" ErrorCode: "Discover_DMTS_Error_Unknown" Message: "There was an error contacting an underlying data source. Manage your credentials or gateway settings on the management page. Please verify that the data source is available, your credentials are correct and that your gateway settings are valid."Actually this capability is rolling out this week, so should be available in all regions by beginning of next week.
You will have to use https://docs.microsoft.com/rest/api/power-bi/embed-token/generate-token for generating the embed token, specify the DatasetId in the request with xmlaPermissions=ReadOnly (https://docs.microsoft.com/rest/api/power-bi/embed-token/generate-token#generatetokenrequestv2dataset)
