Forum Discussion
Model loading error
Hi Joan_Roig ,
Thank you for your Response..!!
This happens when DAX tries to evaluate MAX() in a context where multiple values exist, and it can't determine which single value to use-especially when MAX() is used directly in a filter argument or inside CALCULATE.
Using a variable makes the logic stable and avoids ambiguity errors during evaluation.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly.
Thank you.
Community SupportHi ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Jai-Rathinavel for the prompt response.
Here are some steps that can help to solve the issue:
Step 1: Check for errors in Power Query
Go to Home > Transform Data.
In the Power Query Editor, click on each table on the left.
Look for:
Any red or yellow error messages.
Any columns with “Error” values.
Fix or remove problem columns (like nulls in key columns or failed merge/expand).
If you merged another table, make sure it didn't introduce blank or invalid values.
Step 2: Clear Power BI Cache
Step 3: Remove or simplify relationships (if any)
Go to Model view.
Check if any table relationships have:
A dotted or inactive line.
Circular relationships.
Try deleting one or two complex relationships temporarily and reload.
Step 4: Load tables one at a time (to find the problem)
Save a copy of your file.
Disable load for all but one table:
Right-click a query in Power Query > “Enable load” (uncheck).
Try loading only one table.
Add tables back one at a time to find which one is breaking it.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Hi,
I've tried to change or delete some measures, but the problem is that the model can't update, so the changes aren't applied.
I'm not sure how to make and save these changes.
Any ideas?