Import Table from Power BI Semantic Model

[thomas_f]

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.

As I need to work with the focal table in the query editor and merge other tables, this is not an option. I would like to directly import the table. I remember that this used to be possible via a workaround, adding the URL of the dataset to Power BI Desktop, but I do not see this option under "Advanced" in Power BI service any longer.

Some advice would be very much appreciated.

Thank you!

[Anonymous]

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.

[ibarrau · Accepted solution]

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,

[tommylee2024]

i dont even have the option of connecting live, or import, i can only direct query other semantic models.

[FotFly]

Hi!
I run into a similar problem that I needed to import the table from a premium (diamond) workspace. Everything works fine until I publish my new report to the service, in a pro workspace, and in order to set a scheduled refresh I need to configure my credentials. For the table imported using this method what should the credentials be? I try my microsoft account credentials but it does not work. Is it something I can find in the premium workspace?

PS. In my desktop I can use my microsoft credentials to connect and refresh the table in the new report.

Thank you in advane.

[CGrunberg]

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