Report missing rows deleted from excel file

[Anonymous]

Hi All,

I have changed the excel file my report pulls data from now the report just errors - how do i fix the report to not look for the missing 3 rows

phil

[V-pazhen-msft]

@Anonymous 

Maybe show the images of the excel table and pbi table,  as well as the m codes. 

Paul

[wdx223_Daniel]

@Anonymous if you did not change the M code, which extract data from excel files. then it might be the data type error to cause data missing.

[PhilipTreacy]

Hi @Anonymous 

Hard to say without seeing your source file and the query.

What is the query doing that is causing the error?

Check the step that is causing the error and change it.

If you post the source file and the query I can be more specific.

Phil