Forum Discussion
Fabric - Create semantic model with tables from different workspaces fabric
Hi,
I am struggling to find out a way to create a semantic model with tables from the silver layer and bronze layer. These silver and bronze layer are in each workspace as best practices recommends.
I figured out that i can create a semantic model in a different workspace of tables, but mix tables from different workspaces seems to be impossible ?
Regards,
Nuno
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
2 Replies
- Jonvoge
Most Valuable Professional
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