Forum Discussion

thomas_f's avatar
thomas_f
Regular Visitor
2 years ago
Solved

Import Table from Power BI Semantic Model

Hi all,   I am urgently looking for a possibility to import a table from a Semantic Model stored on Power BI service. I see the options of Live Connection and Direct Quey but not Import mode.   ...
Need Help
  • ibarrau's avatar
    ibarrau
    2 years ago

    Hi. By default, PowerBi Dataset connectors, you can't import a Table. However, there is a workaround for this but only works for paid capacity (ppu, fabric, embed or premium). If you have the Semantic model in a diamond workspace, you can do this.

    Instead of using Get Data and pick the Power Bi Semantic model connector, go to the Analysis Services connector and complete the address with the one that shows the Workspace at the Premium setting:

     

    That will let you connect and impor ta table from the model.

    I hope that helps,

ibarrau's avatar
ibarrau
Super User
2 years ago

Hi. By default, PowerBi Dataset connectors, you can't import a Table. However, there is a workaround for this but only works for paid capacity (ppu, fabric, embed or premium). If you have the Semantic model in a diamond workspace, you can do this.

Instead of using Get Data and pick the Power Bi Semantic model connector, go to the Analysis Services connector and complete the address with the one that shows the Workspace at the Premium setting:

 

That will let you connect and impor ta table from the model.

I hope that helps,

CGrunberg's avatar
CGrunberg
Advocate I
2 years ago

Does this only work for the default semantic model or also for additional semantic models?