Forum Discussion
Update ODBC query
Hello Giulia,
If you've made change in the report published in PowerBI Services and don't want to loose it when you will published the updated dataset Linked to this report, I think that the only solution is to make a copy of the original report in PowerBI Services. You work on the copied report (fortunately you can change his name). So when you will published the updated dataset, only the original report will be overwritten and not the copy.
Sebastien
Hi Giulia,
The dataset and the report are linked together. You can change the name of the dataset or the report in Power BI but not the link between them.
When you publish a .pbix file, it publish both the dataset and the report. Even if you rename the report, as it's linked with the dataset you overwrite, the report will be updated too.
If you want to keep the older one, the best way, is to copy the report in Power BI Services. So when you will update your dataset, you will update the report in the pbix file, but not the copy. But the copy will still be connected to your dataset.
Sebastien
Hi Sebastien,
I'm sorry but maybe I don't understand.. I would like to update the dataset in Power BI Services without updating the liked report, it's not possible?
An example: I build a dataset and a report in Power BI Desktop. When I'm ready, I publish it to Power BI Services, I share it with my supervisor for approval, then I publish it as an Organizational Content Pack.
A few month later my team needs to add some information to the report, so I need to add a column in my dataset. How should I make it? I must have backed up my original .pbix file, reload it in Power BI Desktop, make the changes I need then republish it to Power BI Services losing every change I made online after the first publish to Power BI Services? Am I correct?
Hello Giulia,
If you've made change in the report published in PowerBI Services and don't want to loose it when you will published the updated dataset Linked to this report, I think that the only solution is to make a copy of the original report in PowerBI Services. You work on the copied report (fortunately you can change his name). So when you will published the updated dataset, only the original report will be overwritten and not the copy.
Sebastien