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

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

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago
    Hi still unable to see tables in wh from power bi
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

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

      • 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