Forum Discussion

PPGGG's avatar
PPGGG
New Member
1 year ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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