Forum Discussion

tan_thiamhuat's avatar
tan_thiamhuat
Post Patron
5 months ago
Solved

Power BI linked to OneLake catalog

I am able to link the tables in the Lakehouse via OneLake catalog. And bring in the relevant tables.

However, I am not able to perfrom Visualization based on those tables. Why? Anything I have missed out?

  • v-priyankata's avatar
    v-priyankata
    5 months ago

    Hi tan_thiamhuat 

    Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.

     

5 Replies

  • Hi tan_thiamhuat 

     

     Are you able to provide some more information please?
    Do you receive an error message?
    Do the tables have data once available in Power BI?

    What level of permission do you have on those tables (Workspace access or item level?)

    --------------------------------

    I hope this helps, please give kudos and mark as solved if it does!

     

    Connect with me on LinkedIn.

    Subscribe to my YouTube channel for Fabric/Power Platform related content!



  • Hi tan_thiamhuat ,

     

    give us more information as example.

     

    1. Do you use Power BI Desktop?
    2. Do you want to use Power BI in the Power BI service

    Here’s what I would do if I needed to get things done quickly.

    You can do it in Fabric.

    First, create a semantic model.
    To do this, go to the Lakehouse and select “New Semantic Model.”

    Here the first Screenshot:

     


    There, you can select your tables, then open the semantic model and perform your calculations.
    You can then create a new report based on the semantic model. See screenshot two.

     

     

    But there are other ways.

     

    Best regards

    Rene

     

    Feel free to leave kudos or accept it as a solution. This will also help other community members.

  • Hello tan_thiamhuat

    This is expected when connecting to Lakehouse tables via the Microsoft Fabric OneLake catalog in Power BI.

    The catalog exposes tables, but it does not automatically create a semantic model (dataset), which is required to build visuals.

    Fix:
    Create a semantic model from the Lakehouse (New semantic model), or connect via the SQL endpoint, and ensure you have Build permission.


    Docs:

    What is Power BI 
    What is a lakehouse in Microsoft Fabric? 
    Semantic models in the Power BI service 


    Summary:

    No semantic model = no visuals. Create or connect to one to resolve the issue.

  • v-sgandrathi's avatar
    v-sgandrathi
    Community Support

    Hi tan_thiamhuat,

    Thank you Olufemi7 spaceman127 and wardy912 for your responses to the query.

    we haven't heard back from you regarding Super users last response and wanted to check if your issue has been resolved.

    Should you have any further questions, feel free to reach out.
    Thank you for being a part of the Microsoft Fabric Community Forum!

    • v-priyankata's avatar
      v-priyankata
      Community Support

      Hi tan_thiamhuat 

      Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.