Forum Discussion

Joan_Roig's avatar
Joan_Roig
Regular Visitor
1 year ago
Solved

Model loading error

Hi, With any change in the computer or data source, today the data isn't loading into the model, PowerQuery it seems works and update well, but at the end of the model update process I get this erro...
Need Help
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    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.

     

     

v-venuppu's avatar
v-venuppu
Icon for Community Support rankCommunity Support
1 year ago

Hi Joan_Roig ,

Yes, this is a common issue when the model can’t finish loading but you can still make changes without refreshing the entire model.

You can try with the below steps:

Open the PBIX file without triggering a refresh
1.Open the file in Power BI Desktop.

2.If it prompts you to refresh or apply pending changes, click “Discard” or “Cancel”.

3.Go straight to the Model View or Data View.

4.Delete or fix any recent measures, calculated columns, or relationships that might be causing issues.

5.Save the file and try refreshing again.

If that doesn’t help go with the following steps:
 1.Open a backup or make a copy of the file, then follow the same steps.

 2.In Power Query, disable most query loads so only one or two tables load at a time - this helps isolate which part is breaking the model.

 

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! 

Thank you.