fabric data warehouse

[arkiboys]

Helo,
In microsoft fabric I have created ADF pipelines to ingest data into data warehouse.

I also created lakehouse with shortcuts to data warehouse tables.

Question

from power bi desktop, I go to Get data, Fabric and select lakehouse (lh) or warehouse (wh).

Power bi does not show the tables in lh/wh. Anything I should do?

Thanks

[arkiboys]

please note that power bi is only able to see the tables if I create a semantic model. 

But I want to see why power bi does not see the tables in lh or wh

thank you

[v-nikhilan-msft]

Hi @arkiboys 
If you want to define your own data model you need to connect to the SQL endpoint.

https://learn.microsoft.com/en-us/fabric/data-warehouse/create-reports

I created a new warehouse.

 

When you click on connect the existing tables in the semantic model of the Fabric Warehouse will be displayed in Power BI. 
When you click on Connect to SQL endpoint, you can create your own model.



You can select the tables when connected to SQL endpoint:

You can choose Import or Direct query as per your requirement.



When you click on load,the desired tables will be seen in Power BI desktop. 

 

Hope this helps. Please let me know if you have any further questions.

[v-nikhilan-msft]

Hi @arkiboys 
We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
Thanks

[arkiboys]

Hi still unable to see tables in wh from power bi

[v-nikhilan-msft]

@arkiboys 
Did you follow the steps which I have mentioned above ? Please try connecting to the SQL endpoint.

[arkiboys]

yes, very much so.

power bi looks fo rthe tables, but does not show any tables and no message.

then the GetData menu sub items become disabled

[v-nikhilan-msft]

Hi @arkiboys 

This issue is not happening at my side, hence I am unable to understand what might be the issue here. I request you to create a support ticket, so that our internal team can take a close look on this to find out the reason behind this.

https://support.fabric.microsoft.com/en-US/support/

After creating the ticket please provide the details here so that we can track it internally.

Thanks

[arkiboys]

Hi,

I did raise a ticket with microsoft.

They say I have to have the software fiddler instaled so that they can trace what is happening. The support person did not seem confident though...

In-case it helps here is the ticket:

TrackingID#2404290050001422

thank you

[v-nikhilan-msft]

Hi @arkiboys 

Thanks for providing the details. I will track it internally.

Meanwhile just to understand what might be the issue, can you please create a new warehouse and use the sample data to load the warehouse. Then try connecting to Power BI.

Let me know the results.

Thanks

[arkiboys]

hi, do you mean any sample data?

to test the issue I have created multiple warehouses in which I have tables, etc.

in sql query I can select from tables and join them...

from power bi, Get data, microsoft Fabric, datawarehouses, (It sees the ware houses and I select any one of them), then power bi starts searching but then without errors simply does not show any tables and the get data menue becomes greyed out.

[v-nikhilan-msft]

@arkiboys 

Did you sign in to the power bi desktop with the same account as that of Fabric?

Please check this and let me know. I am asking you to create a new warehouse and you have an option called load sample data in warehouse. When you select that, the warehouse automatically gets loaded with sample data. Then try using Power BI to connect.

[arkiboys]

loaded the test1_wh with sample data which has Geography, Time, Trip, Weather... tables.

same problem with power bi.

[v-nikhilan-msft]

@arkiboys 
Are you trying to connect to the Warehouse where you are the admin of the Warehouse? or are you trying to connect to a warehouse which has another admin?

If the warehouse is created by someone else, then you need to have the permissions to the Artifact (Warehouse and SQL endpoint) in Fabric. And also you need to have the ReadData permissions so that you can read from the tables in the Warehouse.

[arkiboys]

in powerbi desktop, I am logged in - 

in fabric warehouse, I am logged in

not sure where else to check  as I seem to be logged in both areas.
please note, I created the warehouse and power bi desktop

thanks

[v-nikhilan-msft]

Hi @arkiboys 
Thanks for using Fabric Community.
Are you following the below steps:

After making the connection, you can find the tables. Please let me know if the issue still persists.
Hope this helps.

[arkiboys]

yes, I am following the steps but power bi does not show the tables