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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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