topic Re: Can't see Warehouse tables from PBI Desktop in Data Warehouse

Can't see Warehouse tables from PBI Desktop

alfBI — Fri, 07 Mar 2025 10:26:47 GMT

Dear colleagues,

We have created a Datawarehouse on Fabric that contain some view/tables,

When trying to consume these tables from PBI Desktop the tablles/views does not appear

but if the connection to the datwarehouse is done through the SQL End point the tables does appear

Any idea about why this behaviour?

Thx

Alfons

Re: Can't see Warehouse tables from PBI Desktop

ahmetyilmaz — Fri, 07 Mar 2025 11:22:39 GMT

Hello, create a new semantic model in the warehouse.

Select the tables you will use in the model and click confirm.

In Power BI, select PowerBI semantic models.

Select the semantic model you created for the Warehouse and click confirm.

Now you can also view the tables in powerbi.

Re: Can't see Warehouse tables from PBI Desktop

Anonymous — Mon, 10 Mar 2025 11:53:44 GMT

Hi alfBI

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. . Please feel free to contact us if you have any further questions. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Re: Can't see Warehouse tables from PBI Desktop

AndyDDC — Tue, 11 Mar 2025 22:24:47 GMT

Hi alfBI the 2 options you see when connecting to Warehouse from Power BI desktop are:

Connect - this connects to the default semantic model. If you haven't updated this, then no tables will apear
Connect SQL Endpoint - this connects to the actual Warehouse itself and is what you want to do if you create a new semantic model

Re: Can't see Warehouse tables from PBI Desktop

alfBI — Wed, 12 Mar 2025 08:05:40 GMT

Hi Andy,

Thx for the explanation. I now understand what was going wrong. Effectively after adding the table on the default WH semantic model I was able to see the table on the DWH connection. After adding it to our semnatic model added table appears on DirectQuery Storage, instead of the Import one that appears on the table imported using the SQL Endpoint.

I understand that this is the expected behaviour but would be possible to use the WH table available through the semantic model on import mode?

Just a last question. I have added tables to the model using from 2 differents WH using the SQL End point on both cases (as far as I know), and when I check the semantic model lineage I see that one appears as a Warehouse and the other as a SQL Server. Any explanation about this different behaviour?

Thx

Re: Can't see Warehouse tables from PBI Desktop

AndyDDC — Wed, 12 Mar 2025 21:12:08 GMT

Hi alfBI why do you want to use the default semantic model to import tables into another model? That is 1 more unnecessary hop, just use the SQL Endpoint to get the tables you need. I would leave the default semantic model alone tbh.

How have you connected to both the Warehouses? I tested connecting using "Warehouse" in Power BI Desktop and Import mode, and I can see 2 Warehouse connections in the lineage