Publishing from Desktop overwrite report

[azizdoghmi]

Hi, 

I have a workpace "Reporting" with a report "Report1" and a dataset "Master".

When I am using the same dataset from power bi desktop and I publish the report, the existing "Report1" is overwritten.

Before, It was not overwritting but adding a second report named "Master".

I don't know why it is changing.

Can someone know how to do to not overwrite the existing report?

I do not want to create the report from web because I have added some calculation in the dataset.

thanks a lot

[v-robertq-msft]

Hi, @azizdoghmi 

According to your description, you want to create a report using the same dataset and publish it to service without replacing the original version of the report. I think you can try to click the “save as” and use the different name to save the pbix file again, and the report will be published to service without replacing the original version of the report, like this:

And you can get what you want.

More info about connecting to dataset in Power BI desktop

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[azizdoghmi]

Hi @v-robertq-msft ,

Thanks for your help.

Unfortunately, when I use a different name it creates a new dataset also.

I need to have the same dataset for the 2 reports.

thks

[v-robertq-msft]

Hi, @azizdoghmi 

According to your description, you want to publish a new report to the same workspace from the Power BI desktop and don’t add a new dataset in the workspace, I think you can try to connect to the dataset in the desktop and publish to the same workspace. After my test, this method will add a new report to the workspace without adding the same dataset with another name, you can take a look at my method:

1. Connect to the dataset in desktop:

2. Then create the report, click save as to name the report with a different name

3. Then go to the Service, I found the report is added and the dataset is same as before:

And you can achieve what you want. For more information, please check this document:

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

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[azizdoghmi]

Hi @v-robertq-msft 

When you save as with a different name, you have a new dataset and a new report.

This is not what I need to have.

For example, I have a dataset V1 that I publish. It creates a report "V1" thaht I rename "reportv1".

If I add a measure to the dataset v1, I have to republish.

 - If I keep the name V1, it overwrites the "reportv1"

  - If I rename the dataset V2, I have now 2 datasets and two reports "reportv1" and "v2".

I need to have only one dataset that is not overwriting the existing report but creatin a new one when publishing.

thks

[v-robertq-msft]

Hi, @azizdoghmi 

According to your description, I think you have not understood the suggestion I gave before.

If you don’t want to add a new dataset to your workspace when you publish your report to your workspace again, you should try to use the “Connect to Power BI dataset” method to connect to the data source instead of changing the existed pbix file downloaded of Service, like this:

Then search and select your dataset:

Then create a new report to publish to Power BI service.

Please follow this document:

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

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[azizdoghmi]

Thnaks Robert but I have an error message : 

[v-robertq-msft]

Hi, @azizdoghmi 

According to this error message, I think the reason is that you have connected to one data source in this pbix file. To use the live connection in Power BI, you can only connect to one data source.

As a result, I suggest you to create a new pbix file to connect to this dataset to avoid this problem.

What’s more, there is a new feature that allows DirectQuery for Power BI datasets and Azure Analysis Services, you can take a look and find if it can help you to achieve more requirements:

https://powerbi.microsoft.com/en-us/blog/directquery-for-power-bi-datasets-and-azure-analysis-servic...

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Needs more information. is the report using the dataset as a (live) data source?

[azizdoghmi]

Yes, the report is using the dataset as live data source.

thks