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

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

  • 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