Forum Discussion
Power BI Service Cross Workspace Reports Sync
Hello Power BI Community,
I have a situation where I've created two workspaces, A and B, in the Power BI service:
Workspace A: Contains a dataflow and several reports connected to this dataflow.
Workspace B: Also contains a dataflow with the same data structure and column names as the dataflow in Workspace A.
I have copied the reports from Workspace A to Workspace B. Now, I need these copied reports to automatically sync or connect with the dataflows in Workspace B rather than the ones in Workspace A.
Note: I don't want to use Power BI Desktop
Can't do that. You need to duplicate the semantic model and then change the connection details in the copy.
4 Replies
j_oceanHelper V
Reports connect to datasets/sematic models, I assume that's what you mean.
A report copied or moved from Workspace A to Workspace B will still connect to the original semantic model. If you switch to lineage view, there should be a marker referencing it with a little link icon on it identifying/sending you to the model's workspace.
- The DATA will keep in sync with the model through this connection.
- The report DESIGN will not--if you copied a report, changing the color scheme in Workspace A will not propagte to Workspace B.
- Archiving the report becomes more difficult, as reports which originated or which read data across workspace lines can't be downloaded as a pbix for archiving.
You really should be using Desktop for building reports that are used in production. Web editing is good for one-off studies, your personal playground, and such, but is really unsuited for enterprise scale reporting.
- lbendlin
Super User
Reports do not connect to dataflows. Semantic models ingest data from dataflows. Reports are based on semantic models.
Not really clear what you are trying to achieve. Are you looking for CI/CD guidance?
- lbendlin
Can't do that. You need to duplicate the semantic model and then change the connection details in the copy.