Publishing a Power BI Project (PBIP) with one dataset and multiple reports

[pstrombe]

I have a Power BI Project (PBIP) with one dataset and multiple reports (as described here in "Multiple Reports and Datasets at the same folder": Deep dive into Power BI Desktop Developer Mode (Preview) | Microsoft Power BI Blog | Microsoft Power...).

The reports "Sales.Report" and "SalesOverview.Report" are both connected to "Sales.Dataset." I now want to publish this configuration to a Power BI Service workspace from my local machine.

The problem is that no matter which report I open in Power BI Desktop, it opens connected to the dataset. If I then proceed to publish the report, it publishes the dataset as well with the name of the report. Publishing both reports results in two datasets "Sales" and "SalesOverview" being published to the workspace. Is there a way to prevent this?

I want the workspace to have only one dataset but two reports connected to it. I don't have Power BI Premium or Fabric license, so using deployment pipelines is not an option. I am trying to use a Power BI Project for version control.

[Anonymous]

HI @pstrombe,

You can publish the first report to power bi service side, then you can get data from the semantic model that first report created with live connection mode and design correspond contents and publish.

After these steps, you will have to report that design based on one model.

In addition, you can also try to directly design the second report based on the first report models on power bi service.

Regards,

Xiaoxin Sheng

[pstrombe]

Thanks for the response!

The approach you described would certainly work in some cases but unfortunately not in ours. I would like to have a local copy of the entire workspace that can be connected to either a production or development database.

With your approach, I would need to have a separate online workspace for develpoment and production, deploy the datasets separately from the reports and manage the connections between reports and datasets manually (in addition to managing the connections between datasets and databases). This is actually our current setup that I was trying to get rid of by using Power BI Projects. 

It seems that Power BI Projects don't (yet) support the functionality I'm looking for - back to the drawing board it is 😞