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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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