Forum Discussion
Solved
PowerBI visual breaks
I have a composite model with one dimension table. Two other tables with text data like company and project are coming as direct query from another dataset. Now when i try to create a visualisation b...
Hi PPGGG,
Thank you for reaching out to the Microsoft Fabric Forum Community.
In this scenario, the most effective solution would be to create a central dataset that brings together the required data such as Project and Company using a common key like MasterID. This can be done using dataflows, SQL views, or by building a combined dataset in Power BI. Using this single, unified dataset in your report helps avoid relationship issues and broken visuals.
Best regards,
Prasanna Kumar
Hi PPGGG,
We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.
Warm regards,
Prasanna Kumar