Forum Discussion
Anonymous
5 years agoNot applicable
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
- PhilipTreacySuper User
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_DanielCommunity 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.
- AnonymousNot applicable
Anonymous
Maybe show the images of the excel table and pbi table, as well as the m codes.
Paul