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,
Just following up to see if the suggestion to create a unified dataset using a common key like MasterID helped resolve your issue. Let us know if you need any further guidance or run into any challenges we're here to help.
Best regards,
Prasanna Kumar