copy reports between workspaces

[powerbiexpert22]

I am using two workspaces (Workspace1 and Workspace2). Workspace1 consits of 3 reports which are pointing to SQL Server

I want to create copy of 3 those reports from Workspace1 to Workspace2 and point those 3 reports to Snowflake in Workspace2

All three reports in Workspace1 are pointing to same semantic model. The database , schema and table structure is exactly same between SQL Server and Snowflake including naming convention. how to acheive this in Power BI?

[v-veshwara-msft]

Hi @powerbiexpert22 ,
Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
Thank you.

[v-veshwara-msft]

Hi @powerbiexpert22 ,
Thanks for reaching out to Microsoft Fabric Community.

As already suggested by @rohit1991 and @danextian you'll need to download the PBIX file containing the semantic model, open it in Power BI Desktop, and switch the data source from SQL Server to Snowflake and then republish to desired Workspace.

Please visit this link for additional details to consider while changing the data source from SQL Server to Snowflake: Solved: Migration to Snowflake - Microsoft Fabric Community

Hope this helps. Please reach out for further assistance.

Thank you.

[rohit1991]

Hi @powerbiexpert22 

Since your SQL Server and Snowflake have the same structure, you can just download the reports from Workspace1 as .pbix files, open them in Desktop, and change the data source.

In Power BI Desktop:

1. Open the report
2. Go to Transform Data >> Data source settings
3. Switch the source from SQL to Snowflake (you’ll need the Snowflake connector)
4. Apply changes and make sure everything loads fine
5. Then just publish the report to Workspace2

That’s it the report layout stays the same, just now running on Snowflake. If the model is shared across reports, you’ll need to recreate or repoint the semantic model too

[danextian · Accepted solution]

Hi @powerbiexpert22 

Since you intend to change the data source, you will need the pbix that contains the semantic model and the report and then change the data source. Once published, you can download the remaining others as thin reports, change the semantic model they're using and then publish them. 

[VijayP]

@powerbiexpert22 

If I understood your question correctly, you can place your reports in different workspaces by editing and save as to another workspace and semantic model and datasource will be same for those reports placed other workspaces. Let me know if this is what you are looking for