Forum Discussion

Fabio747's avatar
Fabio747
Copper Contributor
Jun 21, 2023

DataFormat.Error: No value given for one or more required parameters

Hello!

 

I have a connection to get data from an Access query. At the end of update, I see this warning: DataFormat.Error: No value given for one or more required parameters

 

What could be the cause?

 

thanks in advance!

Fabio

excel

1 Reply

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jun 22, 2023

    Hello Fabio747 

     

    Virtually impossible to answer your question with an error message only. Though, have a look to https://stackoverflow.com/questions/28601913/ms-access-no-value-given-for-one-or-more-required-parameters where the OP finally figured it out and was kind enough to share his findings...

     

    (there's also https://community.fabric.microsoft.com/t5/Power-Query/Need-your-help-in-solving-DataFormat-Error-No-value-given-for/m-p/2341424 but reading it briefly it seems it led nowhere but to an undocument resolution)

Resources