Data Refresh has stopped working

[Dragons2566]

All of a sudden I have been getting the following error code when trying to refresh our data. nothing has changed with file locations so I cant understand why the issue is occuring.

Any help would be apprecieated.

Thanks

[Anonymous]

Thanks for the reply from Jai-Rathinavel and Bibiano_Geraldo , please allow me to provide another insight:

Hi, @Dragons2566 

The answers from Jai-Rathinavel and Bibiano_Geraldo regarding your question are excellent. If their responses have been helpful, I hope you will consider accepting them as a solution.

Regarding GPSData: the message “The number of arguments passed to the FILTER function is too few. The minimum number of parameters for this function is 2.” indicates that when using the FILTER function, you need to provide at least two parameters. Please check your DAX formula to ensure that all required parameters are correctly passed. I suspect that a change in your data structure may have caused the EARLIER() function to be unable to locate the column, resulting in this error.

Here are the relevant document screenshots:

For further details, please refer to:

Data refresh in Power BI - Power BI | Microsoft Learn

FILTER function (DAX) - DAX | Microsoft Learn
EARLIER function (DAX) - DAX | Microsoft Learn
EARLIEST function (DAX) - DAX | Microsoft Learn
 

As for the activity names, calendar, and injury status: the loading of these tables has been cancelled with the message “Loading was cancelled due to an error in loading a previous table.” This typically indicates a dependency issue within the data model. You may need to check the loading order of these tables or the connection to the data source.

 
Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jai-Rathinavel]

Hi Dragon2566,

The column passed in the EARLIER / EARLIEST Function  might have a blank / null value. Please check the source column which is used to create the calculated column in GPSData table

Thanks, 
Jai 🙂

[Bibiano_Geraldo]

Hi @Dragons2566 ,

As showed in prompt, in the GPSData you got error with FILTER and EARLIER functions, you need to double check all you calculated columns that have this functions applied.

thank you