Forum Discussion
copy reports between workspaces
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?
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.
5 Replies
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
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.
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:
- Open the report
- Go to Transform Data >> Data source settings
- Switch the source from SQL to Snowflake (you’ll need the Snowflake connector)
- Apply changes and make sure everything loads fine
- 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
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.
Hi powerbiexpert22 ,
Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
Thank you.
