Forum Discussion
Publishing from Desktop overwrite report
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:
- Connect to the dataset in desktop:
- Then create the report, click save as to name the report with a different name
- 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.
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
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.
Thnaks Robert but I have an error message :
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:
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.