PowerBI visual breaks

[PPGGG]

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 based on a filed in no mod dimension and project name from project and company name from from company, the visual breaks saying that there is no relationship.
While relationship is there from dimension to project as one to many and dimension to company as one to many

Can I get a solution for this.

[v-pgoloju]

Hi @PPGGG,

Just a gentle reminder  has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Thank you for your time and feedback!

Best,

Prasanna Kumar

[v-pgoloju]

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

[v-pgoloju]

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

[v-pgoloju · Accepted solution]

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

[burakkaragoz]

Hi @PPGGG ,

Yeah, this happens a lot with composite models in Power BI, especially when you’re mixing Import and DirectQuery sources. Even if you’ve set up the relationships, Power BI visuals can break when you try to use fields from more than one DirectQuery source in a single visual. It’s a known limitation — the engine just can’t resolve relationships between multiple DQ sources at once.

The suggestion above is definitely right: the most reliable workaround is to import at least one of your DirectQuery tables into the model. That way, your visual only references a single DirectQuery source, which Power BI supports. If you absolutely need to use both tables in DQ mode together, you might need to rethink your model or use dataflows/pre-joined tables as prep.

If you want, I can help walk through importing a table or restructuring your visual logic — just let me know!

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI

[PPGGG]

Can you suggest any other solution because this characteristics are required to be in a separate data model which need to be used as direct query only

[rajendraongole1]

Hi @PPGGG -I strongly suggest importing at least one of the DirectQuery tables into the model.Try to restructure your visual or report logic so that it includes only one of the DirectQuery sources at a time. This is the most straightforward workaround.Use Only One DirectQuery Source per Visual

Hope this helps.