3 semantic models + DAX table - Refresh Issue

[AbdulRahman86]

Hello Experts, 

I wanted to take your advice regarding Data Refresh : Problem statement as follow

I have take bunch of tables from 3 different semantic models into single power bi desktop

to create relationships between these tables I created 2 more DAX table. Everything is working as expected so far.

Now, When I am trying to refresh this report in PowerBI Service it is throwing an error because of DAX Table.

So, How should we convert this DAX table into a separte Semantic model to avoid refresh failure or do you have any other approach.

[Akash_Varuna]

Hi @AbdulRahman86 I think this is occurring because DAX tables depend on other model tables and are recalculated during refresh, which isn't fully supported in Power BI Service for multiple semantic models. To resolve this, materialize the DAX table into one of the semantic models or replicate its logic in a Power BI Dataflow. Alternatively, pre-join or flatten relationships in the semantic models to eliminate the need for intermediate DAX tables.