Creating an Embedded Power BI Report using a Dataset created by A Datamart?

MichaelWash — Tue, 12 Jul 2022 23:21:44 GMT

Currently, if we call the API to create a report (passing in a Workspace and a Dataset) it will work for any dataset, except a dataset that was created by a Datamart

private async void DisplayReportAsync() { var accessToken = await @PowerBIService.GetPowerBIAccessTokenAsync(); var tokenCredentials = new TokenCredentials(accessToken, "Bearer"); selectedWorkspaceID = selectedPowerbiWorkSpace.ToString(); using (var client = new PowerBIClient( new Uri(_powerBISettings.ApiUrl), tokenCredentials)) { var generateTokenRequestParameters = new GenerateTokenRequest( accessLevel: TokenAccessLevel.Create, datasetId: SelectedDatasetId, allowSaveAs: true ); // For help see: https://bit.ly/2TbYjFl var tokenResponse = await client.Reports.GenerateTokenForCreateAsync( new Guid(selectedWorkspaceID), generateTokenRequestParameters); string CreateReportEmbedURL = colDatasets.Where(x => x.Id == SelectedDatasetId) .FirstOrDefault().CreateReportEmbedURL; objRef = DotNetObjectReference.Create(this); await Interop.CreateNewReport( JSRuntime, PowerBIElement, tokenResponse.Token, CreateReportEmbedURL, SelectedDatasetId, objRef ); } }

We get:

Re: Creating an Embedded Power BI Report using a Dataset created by A Datamart?

v-chenwuz-msft — Fri, 15 Jul 2022 06:38:27 GMT

Hi @MichaelWash ,

Datamart is in preview. So it is not support current time.Datamart is in preview. So at the current time it does not support power bi embeded.

For more details, you can see this official article.

Administration of datamarts (preview) - Power BI | Microsoft Docs

Please consider creating a composite model in power bi desktop and then using the new dataset. might be an choice.

Create reports using datamarts (preview) - Power BI | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Creating an Embedded Power BI Report using a Dataset created by A Datamart? in Developer

Creating an Embedded Power BI Report using a Dataset created by A Datamart?

Re: Creating an Embedded Power BI Report using a Dataset created by A Datamart?