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

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

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

    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.