Forum Discussion
Organizing lineage flow & publishing process
Hi zenghost22,
This is 100% doable.
Start by making your master semantic model (can be done along side the first report, or made directly in the service)
From there, instead of copying it and publishing a new file each time, in Power BI Desktop use the OneLake connection and connect to existing Power BI semantic Models:
Once that is connected, you are now connected to the existing semantic model. Publishing this report will not create a new one, but will link to the existing one exactly like you are wanting.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Hi zenghost22,
You can only change the semantic model a report is using when it is connected via OneLake. You can't change the model on a traditional report to my knowledge.
If you want the reports to be entirely seperated from the semantic model, then the model needs to be built not attached to a report initially.
I don't know of a way to keep the model and delete just the report when they were built together in power bi desktop.
What you might be able to do is:
Upload your report to your semantic model workspace, that will create the model. Just ignore the report that sits there beside your model.
then open two copies of Power BI Desktop, one that is blank, and one that is your report. On the blank one, connect to the live semantic model that you just uploaded.
Then as long as the tables have the same names, and they should, you should be able to select all elements of the existing report and copy-paste them into the new report.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
This worked and saved me a ton of time. Thank you, tayloramy!
Happy to help!