Forum Discussion
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?
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
- wardy912Super User
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!
- spaceman127Super User
Hi tan_thiamhuat ,
give us more information as example.
- Do you use Power BI Desktop?
- 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.
- Olufemi7Super User
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-sgandrathiCommunity 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-priyankataCommunity Support
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.