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 sh...
Need Help
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