Forum Discussion
Fabric - Create semantic model with tables from different workspaces fabric
Hi NunoTrigo1986
There is nothing stopping you from connecting via Import or DirectQuery to tables from multiple different Lakehouses/Warehouses across multiple workspaces.
However, i suspect you may want to leverage DirectLake?
In that case, the tables do indeed need to be found in the same Lakehouse.
What you need to do, is create a new Lakehouse (you can put it in the same Workspace as your Semantic Model, or put it in its own workspace), and then Shortcut all the tables you need into that new Lakehouse. Then you can build a Semantic Model on top of the new Lakehouse, using all the different tables.
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data
Hi NunoTrigo1986
There is nothing stopping you from connecting via Import or DirectQuery to tables from multiple different Lakehouses/Warehouses across multiple workspaces.
However, i suspect you may want to leverage DirectLake?
In that case, the tables do indeed need to be found in the same Lakehouse.
What you need to do, is create a new Lakehouse (you can put it in the same Workspace as your Semantic Model, or put it in its own workspace), and then Shortcut all the tables you need into that new Lakehouse. Then you can build a Semantic Model on top of the new Lakehouse, using all the different tables.
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data
Great. thanks for your help