Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Report missing rows deleted from excel file

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

3 Replies

  • 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

     

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous 

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


    Paul