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

[frithjof_v]

What happens if you try the following:

1. In your Fabric workspace, click on the ... symbol next to your Warehouse.

2. Select 'Copy SQL connection string'. 

3. Click Copy

4. Create a new report (Blank report) in Power BI Desktop.

5. In Power BI Desktop, click SQL Server

6. Paste the SQL Connection String and click OK

7. Are you able to select the warehouse from the Navigator? 

If not, sounds like there is an issue/bug or lack of permission.

Another thing you could try:

1. Create a new report (Blank report) in Power BI Desktop

2. Create a Blank Query

3. Click Advanced Editor

4. Remove all code contents and paste the following code (insert your specific details):

let
    Source = Sql.Databases("//INSERT YOUR SQL CONNECTION STRING HERE//"),
    Warehouse = Source{[Name="//INSERT YOUR WAREHOUSE NAME HERE//"]}[Data],
    Table = Warehouse{[Schema="dbo",Item="//INSERT YOUR TABLE NAME HERE//"]}[Data]
in
    Table

5. Then click Done.

This should connect to your table in the Fabric Data Warehouse if you have access.

To check if permission / using wrong user is the issue, then you could select Data source settings:

Select the connection to your Fabric Workspace / Data Warehouse.
Click "Clear Permissions".

Confirm by clicking "Delete".

Click "Refresh Preview":

Click "Edit credentials":

Select "Microsoft account" and "Sign in":

Then sign in with the same user account which has access to the data warehouse in the Fabric workspace.

Afterwards, click "Connect".

If that doesn't work, and you know that the user has the necessary permission level to the Fabric workspace / data warehouse, then it sounds like an issue/bug.

[shashankg]

I got an error after step 5 as mentioned above

[frithjof_v]

Interesting.

What happens if you click Edit?

Does this happen also for warehouses in other workspaces?

Did you try the steps I mentioned under "Another thing you could try:". Including the part about clear permission and then sign in again with Microsoft account.

[shashankg]

Dear Microsoft Team,

I am encountering the same issue that user ‘arkiboys’ reported. I sincerely hope that this issue receives prompt attention and resolution. To address this matter, I have raised a Service Request (SR) with the reference number 2407010050000090 through Microsoft support.

[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