Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
plhrja
Regular Visitor

Importing reports with only build rights to different workspaces

We are using the C# API project for automating report deployment. We're encountering problems trying to publish reports with only build rights on datasets.

The following example demonstrates the issue.
Let's assume we have a workspace, say W1, to where a report is published from Power BI Desktop. This results in two entities being formed in W1, say dataset A and report A.  We then go on and create a new report based on dataset A, say report B. We then go ahead and publish it to the same workspace. This results in the following lineage in W1, and with report B having only build rights on dataset A.

plhrja_0-1685950710255.png

We have the same results when using the import API to publish report B to the workspace.

We then want to publish report B to a different workspace, say W2We are able to achieve this through the Power BI Desktop, resulting in the following lineage in W2, with an implicitly created linked Dataset A.

plhrja_1-1685950950728.png

However, when using the import API to import report B to W2, we get an error - Operation returned an invalid status code 'BadRequest'.  The configuration of the API request is to basically overwrite every property that is overwriteable.

 

In essence, we have two questions:

  • Are we misusing the API somehow? Should it be possible to duplicate the effect of the Power BI Desktop Publish -functionality for reports created in this way with the import API?
  • If the import API is not designed for this, is there another way for duplicating the functionality using the REST APIs?
1 ACCEPTED SOLUTION
plhrja
Regular Visitor

Stumbling on unseemingly unrelated documentation, this actually works as intended, and unfortunately is not

supported.

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets 

Reports that share a dataset on the Power BI service don't support automated deployments that use the Power BI REST API.

 

View solution in original post

1 REPLY 1
plhrja
Regular Visitor

Stumbling on unseemingly unrelated documentation, this actually works as intended, and unfortunately is not

supported.

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets 

Reports that share a dataset on the Power BI service don't support automated deployments that use the Power BI REST API.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.