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.

[v-pgoloju]

Hi @AbdulRahman86,

Glad to hear it's working as expected on your end! I’d recommend sharing your approach and marking your own post as the accepted solution. This would be incredibly helpful for others in the community who might face similar issues, allowing them to find and apply the solution more easily.

Thnaks & Regrads,

Prasanna Kumar

[v-pgoloju]

Hi @AbdulRahman86,

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 Regards,

Prasanna Kumar

[AbdulRahman86 · Accepted solution]

Hello Team,

Its been fixed it in a different way. 

thank you so much for your attention.

[v-pgoloju]

Hi @AbdulRahman86,

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 @AbdulRahman86,

Thank you for reaching out to the Microsoft Fabric Forum Community. And also thanks to @Akash_Varuna  for prompt and helpful response.

Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

Best regards,

Prasanna Kumar

[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.