Forum Discussion
Overwrite a semantic model on service from Desktop
- 1 year ago
Hi. Yes that's possible. In order to work like that you need to keep one single pbix file for the dataset prod that will hold only semantic model changes. Not even one for report. Just data model. That one should have always the same name and it will let you replace each time you publish.
The key here is how to build the reports. The reports can be created with PBI Desktop, you just need to get data from "semantic model" or "dataset" from Power Bi Service. Pick the prod semantic model and start creating the UI for the report.
The reports will be just visualizations, no data model. The prod holds the data model. Each time you create a report you create a new blank pbix file and get data from the dataset hub.
When you need a modification to the prod dataset, just edit the prod.pbix file and publish to replace.
I hope that helps,
Hi. Yes that's possible. In order to work like that you need to keep one single pbix file for the dataset prod that will hold only semantic model changes. Not even one for report. Just data model. That one should have always the same name and it will let you replace each time you publish.
The key here is how to build the reports. The reports can be created with PBI Desktop, you just need to get data from "semantic model" or "dataset" from Power Bi Service. Pick the prod semantic model and start creating the UI for the report.
The reports will be just visualizations, no data model. The prod holds the data model. Each time you create a report you create a new blank pbix file and get data from the dataset hub.
When you need a modification to the prod dataset, just edit the prod.pbix file and publish to replace.
I hope that helps,