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,

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi thomas_f ,

Based on my testing, please try the following methods as workaround:

1.Select the table that you want to use. Export the table into the excel file.

2.Click on Get Data, choose the previously excel file.

3.Select Open. The table is imported in the desktop.

4.You can also try to use the dataflow to use the table.

Configure and consume a dataflow - Power BI | Microsoft Learn

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.