Forum Discussion

gopinathna_'s avatar
gopinathna_
Frequent Visitor
4 years ago

Need your help in solving - DataFormat.Error: No value given for one or more required parameters.

Need your help in understanding the reason for this error and how to fix the same. Please find the screen shot. 

 

Problem statement - My data source is from MS Access table. There are few table showing this message while trying to edit query from Power BI for additional calculation.

 

Have checked the file name and format of the data its seems to be ok. For any further details required please revert back ill share those details to fix this issue.

 

Thanks in advance

 

Need Help

6 Replies

  • visheshjain's avatar
    visheshjain
    Impactful Individual
    4 years ago

    Hi gopinathna_ ,

     

    Please can you share a sample file and larger picture of the error as it is not clearly visible.

    This will help us understand the problem better.

     

    Thank you,

    Vishesh Jain

    • gopinathna_'s avatar
      gopinathna_
      Frequent Visitor
      4 years ago

      Dear Vishesh,

       

      Have followed the below steps the issues have been resolved. After creating a duplicate data in the power bi of the same file from the same source the issue of the original file has been resolved. 

       

      Thanks for your support. Still i feel its a Bug

       

      • Danush95's avatar
        Danush95
        New Member
        3 years ago

        Which steps you followed please ping here

  • gopinathna_'s avatar
    gopinathna_
    Frequent Visitor
    4 years ago

    Dear Vishesh Jain,

     

    Thanks for your prompt response. Please find the screen shot of the error along with the sample data from MS Access as well. 

     

    Error Screen shot

    NumberNumberShort TextDate/TimeShort TextShort TextNumberShort TextNumberNumberShort TextShort TextShort TextShort TextShort TextDate/TimeDate/TimeDate/TimeShort TextShort TextShort Text
    Application NoContract NoProduct_NameProposal_Recieved_DateSUD Branch Office/TerritoryProcessing_DayFinal_TATDEQC_TATNo of RequirementMand_ReqNBFTRPhysical_BranchRegionCOMZOMEntryDateTimeFlatFile_UploadDateFinal_DateExit_DateBranch_AMLogin_Month
    124264491731436SUD Life Samriddhi31-Jan-22Mumbai ROSame Day Processing0WithinTAT5 FTRMumbai ROMumbaiHardik ShahAshish Agrawal31-Jan-22 31-Jan-2231-Jan-22 Jan-22
    124264531732704SUD Life Samriddhi31-Jan-22Mumbai ROSame Day Processing0WithinTAT  FTRMumbai ROMumbaiHardik ShahAshish Agrawal03-Feb-2228-Jan-2203-Feb-2203-Feb-22 Jan-22
    124264731730992SUD Life Samriddhi31-Jan-22Mumbai ROSame Day Processing0WithinTAT1 FTRMumbai ROMumbaiHardik ShahAshish Agrawal31-Jan-22 31-Jan-2231-Jan-22 Jan-22
    124264541731442SUD Life Samriddhi31-Jan-22Mumbai ROSame Day Processing0WithinTAT1 FTRMumbai ROMumbaiHardik ShahAshish Agrawal31-Jan-22 31-Jan-2231-Jan-22 Jan-22
    124264741731394SUD Life Samriddhi31-Jan-22Mumbai ROSame Day Processing0WithinTAT1 FTRMumbai ROMumbaiHardik ShahAshish Agrawal31-Jan-22 31-Jan-2231-Jan-22 Jan-22
    124265231731378Saral Jeevan Bima31-Jan-22Surat BOSame Day Processing0WithinTAT62NFTRSurat BOGujaratHardik ShahAshish Agrawal31-Jan-2225-Jan-2231-Jan-2231-Jan-22Vishalkumar PatelJan-22
    124264051730706SUD Life Century Royale31-Jan-22Mumbai ROSame Day Processing0WithinTAT71NFTRMumbai ROMumbaiHardik ShahAshish Agrawal31-Jan-22 31-Jan-2231-Jan-22 Jan-22
    • visheshjain's avatar
      visheshjain
      Impactful Individual
      4 years ago

      Hi gopinathna_ ,

       

      I think you are using parameters in multiple queries, which are not loading, becasue that parameters table is empty.

      Please can you share the sample PBIX file, so investigate this further, in case the above solution does not work.

       

      Thank you,

      Vishesh Jain

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi gopinathna_ ,

     

    Could you tell me if your problem has been solved?
    If it is, kindly Accept it as the solution. More people will benefit from it.


    Best Regards,
    Stephen Tao