Unable to Copy Semantic Model or create a Direct Query

[hstance]

Why in the heck does Power BI not allow copying a semantic model in a workspace? 

I can only "move" a model.

Does anyone know how this is done? Don't tell me I have to use the API?

[v-sshirivolu]

Hi @hstance  ,
I would also take a moment to thank @Shahid12523, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

[v-sshirivolu]

Hi @hstance   ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-sshirivolu]

Hi @hstance ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

[Shahid12523]

Power BI doesn’t let you copy semantic models—only move them—because of workspace-bound metadata and lineage constraints. DirectQuery fails if the model’s in My Workspace or has restricted settings.
Workarounds:
- Use PBIP projects to re-upload
- Deploy via Tabular Editor
- Try Semantic Link Labs for Fabric

[MasonMA]

@hstance 

I would just download the original .pbix file from the current workspace, save the file with a new name and then upload it to the target workspace using the Power BI Service portal.

Maybe you should create an idea in forum and ask people to vote:) 

[djurecicK2 · Accepted solution]

I agree with this if possible. Not all models can be downloaded though- here are the limitations:

https://learn.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix#limitations-when-do...

[djurecicK2]

Hi @hstance ,

 Here is a way to do it programatically:

https://www.data-nova.io/post/clone-rebind-powerbi-semantic-models

Depending on the type of model, you could possibly download it and then publish a copy.

https://learn.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix#download-a-pbix-fil...