PowerBI visual breaks

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