topic Re: Embedding Paginated Report with a Power BI Dataset in Developer

Embedding Paginated Report with a Power BI Dataset

Anonymous — Wed, 15 Jul 2020 17:44:51 GMT

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.

Re: Embedding Paginated Report with a Power BI Dataset

Anonymous — Tue, 18 Aug 2020 21:30:29 GMT

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 ?

Re: Embedding Paginated Report with a Power BI Dataset

chrisfin — Tue, 18 Aug 2020 22:05:42 GMT

It is a known limitation when embeddeding a paginated report in the "app owns data" scenario - @avive and team are working to unblock that in the coming months.

Re: Embedding Paginated Report with a Power BI Dataset

Anonymous — Tue, 18 Aug 2020 23:55:17 GMT

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

Re: Embedding Paginated Report with a Power BI Dataset

Anonymous — Wed, 11 Nov 2020 23:59:15 GMT

Chris - Any headway on "app owns data" for embedded paginated reports - Phil

Re: Embedding Paginated Report with a Power BI Dataset

chrisfin — Mon, 16 Nov 2020 18:37:16 GMT

The team that owns this hasn't yet been able to fund the work, so right now it won't happen until sometime in 2021 it looks like.

Re: Embedding Paginated Report with a Power BI Dataset

Eugene_Ov — Wed, 06 Jan 2021 13:58:21 GMT

@chrisfin

Do you consider to allow datasets published using XMLA endpoint as well? Or it only relates to datasets published by Desktop app?

Eugene.

Re: Embedding Paginated Report with a Power BI Dataset

Anonymous — Thu, 17 Jun 2021 11:03:38 GMT

Hi Chris,

Just wanted to check if there are any news on this front? My organization is using shared PBI datasets for paginated reports which aren't supported for embedding at the moment, so just wanted to check if this might change soon before taking the route of completely redesigning data sources.

Re: Embedding Paginated Report with a Power BI Dataset

Anonymous — Wed, 15 Dec 2021 15:01:47 GMT

Can we get an update on this issue and when it will be fixed?

Re: Embedding Paginated Report with a Power BI Dataset

chrisfin — Wed, 15 Dec 2021 19:43:25 GMT

I'm not on the paginated reports team any longer, so I'm not sure when this will be addressed, though I believed it should have been rolled out by now. @avive might know the latest.

Re: Embedding Paginated Report with a Power BI Dataset

avive — Thu, 16 Dec 2021 13:48:53 GMT

We are marching towards having this available by Jan in production

Hope this helps

Aviv

Re: Embedding Paginated Report with a Power BI Dataset

Sri_1234 — Mon, 10 Jan 2022 14:09:26 GMT

Any update on this issue. We are having the same problem and looking for the solution.

Thank you,

Sri

Re: Embedding Paginated Report with a Power BI Dataset

Anonymous — Mon, 10 Jan 2022 14:42:55 GMT

Well, it's January 10th, so is going to be Jan or when do you think? Just wanted a guesstimate is all.

Re: Embedding Paginated Report with a Power BI Dataset

pbi-master — Wed, 12 Jan 2022 21:27:11 GMT

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."

Re: Embedding Paginated Report with a Power BI Dataset

AmosHersch — Thu, 13 Jan 2022 06:26:52 GMT

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)

Re: Embedding Paginated Report with a Power BI Dataset

avive — Sun, 16 Jan 2022 18:02:09 GMT

Please give it another week

Thanks

Aviv

Re: Embedding Paginated Report with a Power BI Dataset

AmosHersch — Tue, 18 Jan 2022 13:56:33 GMT

This is now available. You should use the latest .Net SDK, see some guidance here:

https://docs.microsoft.com/en-us/power-bi/developer/embedded/embed-paginated-reports?tabs=customers#step-6---embed-content-using-the-sample-application

Thanks,

Amos

Re: Embedding Paginated Report with a Power BI Dataset

Anonymous — Mon, 24 Jan 2022 13:01:09 GMT

So, we have implemented the code in our .net application and we are able to see our paginated report through our embedded web application. However, we are seeing an issue where the provided EffectiveIdentity username is not showing correctly in the Paginated Report's username parameter. This parameter is showing the &User.UserId property, however, this value has the service principal GUID instead of the effective identity username provided in the api call. Code in call:

generateTokenRequestV2Parameters = new GenerateTokenRequestV2(datasets: dataSetIdV2, reports: reportIdV2, identities: new List<EffectiveIdentity> { new EffectiveIdentity(username: upn, roles: new List<string> { roleName }, datasets: new List<string> { dataSetId }) });

accessToken = client.EmbedToken.GenerateToken(generateTokenRequestV2Parameters);

The upn value in this case is my email address 'xxxxx.xxxxxx@xxxx.com', which should show up in the pagainated report parameter for &User.UserId instead of the SPN GUID.

Re: Embedding Paginated Report with a Power BI Dataset

AmosHersch — Mon, 24 Jan 2022 14:48:57 GMT

Hi,

When you provide an effective identity in the generateToken request it should either be an effective identity for the paginated report or an effective identity for the Power BI dataset.

If you want the username to be the identity passed to the report then should should provide the reportId and not the datasetId. Something like this:

new EffectiveIdentity(username: upn, , reports: new List<string> { reportId })

In addition you can specify another identity for the dataset, with the roles, etc.

Thanks,

Amos

Re: Embedding Paginated Report with a Power BI Dataset

Anonymous — Mon, 24 Jan 2022 15:15:22 GMT

Thank you, that was very helpful. In order to make it work, I had to provide both identities (one for report, one for dataset) otherwise I would get a bad request error. Would you happen to have any documentation on using multiple identities? I don't think I would have ever thought to do that, so thank you.