Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

fabric data warehouse

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 t...
power bi
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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

    same problem with power bi.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Anonymous 

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Anonymous 
    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.