Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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.
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 W2. We are able to achieve this through the Power BI Desktop, resulting in the following lineage in W2, with an implicitly created linked Dataset A.
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:
Solved! Go to Solution.
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.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
4 | |
3 | |
3 | |
3 | |
3 |