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

[gopinathna_]

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

[Anonymous]

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

[gopinathna_]

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

Number

Number

Short Text

Date/Time

Short Text

Short Text

Number

Short Text

Number

Number

Short Text

Short Text

Short Text

Short Text

Short Text

Date/Time

Date/Time

Date/Time

Short Text

Short Text

Short Text

Application No

Contract No

Product_Name

Proposal_Recieved_Date

SUD Branch Office/Territory

Processing_Day

Final_TAT

DEQC_TAT

No of Requirement

Mand_Req

NBFTR

Physical_Branch

Region

COM

ZOM

EntryDateTime

FlatFile_UploadDate

Final_Date

Exit_Date

Branch_AM

Login_Month

12426449

1731436

SUD Life Samriddhi

31-Jan-22

Mumbai RO

Same Day Processing

0

WithinTAT

5

FTR

Mumbai RO

Mumbai

Hardik Shah

Ashish Agrawal

31-Jan-22

31-Jan-22

31-Jan-22

Jan-22

12426453

1732704

SUD Life Samriddhi

31-Jan-22

Mumbai RO

Same Day Processing

0

WithinTAT

FTR

Mumbai RO

Mumbai

Hardik Shah

Ashish Agrawal

03-Feb-22

28-Jan-22

03-Feb-22

03-Feb-22

Jan-22

12426473

1730992

SUD Life Samriddhi

31-Jan-22

Mumbai RO

Same Day Processing

0

WithinTAT

1

FTR

Mumbai RO

Mumbai

Hardik Shah

Ashish Agrawal

31-Jan-22

31-Jan-22

31-Jan-22

Jan-22

12426454

1731442

SUD Life Samriddhi

31-Jan-22

Mumbai RO

Same Day Processing

0

WithinTAT

1

FTR

Mumbai RO

Mumbai

Hardik Shah

Ashish Agrawal

31-Jan-22

31-Jan-22

31-Jan-22

Jan-22

12426474

1731394

SUD Life Samriddhi

31-Jan-22

Mumbai RO

Same Day Processing

0

WithinTAT

1

FTR

Mumbai RO

Mumbai

Hardik Shah

Ashish Agrawal

31-Jan-22

31-Jan-22

31-Jan-22

Jan-22

12426523

1731378

Saral Jeevan Bima

31-Jan-22

Surat BO

Same Day Processing

0

WithinTAT

6

2

NFTR

Surat BO

Gujarat

Hardik Shah

Ashish Agrawal

31-Jan-22

25-Jan-22

31-Jan-22

31-Jan-22

Vishalkumar Patel

Jan-22

12426405

1730706

SUD Life Century Royale

31-Jan-22

Mumbai RO

Same Day Processing

0

WithinTAT

7

1

NFTR

Mumbai RO

Mumbai

Hardik Shah

Ashish Agrawal

31-Jan-22

31-Jan-22

31-Jan-22

Jan-22

[visheshjain]

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

[visheshjain]

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_]

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]

Which steps you followed please ping here