Forum Discussion
Microsoft EmployeeFabric - Create semantic model with existing tables via Microsoft Fabric API
Hi Winds ,
Do you want to create a semantic model with data from Lakehouse?
As far as I know, currently Power BI doesn't support us to achieve this goal directly.
I suggest you to create a Dataflow in Power BI Service and then create a semantic model by this Dataflow. The Lakehouse connector is a beta connector. And we need to create dataflow manually.For reference:
Power Query Lakehouse (Beta) connector - Power Query | Microsoft Learn
Where to get data - Power Query | Microsoft Learn
If you want to learn more about sensitivity label, please refer to this blog: Sensitivity labels from Microsoft Purview Information Protection in Power BI - Power BI | Microsoft Learn.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Winds ,
As far as I know, for the time being, there is only support for manually selecting a Table to create a Semantic Model. The ability to use the REST API to achieve this effect should not be pushed.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Winds ,
Do you want to create a semantic model with data from Lakehouse?
As far as I know, currently Power BI doesn't support us to achieve this goal directly.
I suggest you to create a Dataflow in Power BI Service and then create a semantic model by this Dataflow. The Lakehouse connector is a beta connector. And we need to create dataflow manually.
For reference:
Power Query Lakehouse (Beta) connector - Power Query | Microsoft Learn
Where to get data - Power Query | Microsoft Learn
If you want to learn more about sensitivity label, please refer to this blog: Sensitivity labels from Microsoft Purview Information Protection in Power BI - Power BI | Microsoft Learn.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Microsoft EmployeeThank you so much! Anonymous
Just want to confirm, What we want to do is creating semantic model based on the existing table shortcut in LakeHouse.
1. In Fabric LakeHouse, "New Semantic Model"
2. Create semantic model with the selected table in specific workspace. (TestFabricWP in the picture)
We aim to automate this process using the FabricAPI. Is this currently possible, or could it be in the future?
If not, is there a way to achieve this goal while minimizing manual work?
Hi Winds ,
As far as I know, for the time being, there is only support for manually selecting a Table to create a Semantic Model. The ability to use the REST API to achieve this effect should not be pushed.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.