Forum Discussion

Dragons2566's avatar
Dragons2566
New Member
1 year ago

Data Refresh has stopped working

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

Need Help

3 Replies

  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    Super User
    1 year ago

    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

  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    Super User
    1 year ago

    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 đź™‚

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.