Unexpected Error

[shareezsaleem]

Hi Team,

I have build a report in Power BI and while matching the values with the manually maintained excel sheet with Power BI, its not tallying.

While I refreshes the data in Power Query, it is showing me something like this.

Note: We have added 4 to 5 columns in SAP table.

How can I fix this error without effecting my report?

[amitchandak · Accepted solution]

@shareezsaleem , Add the table separately , Take the first few lines and replace in the current query carefully

something very similar to

Change Connection from One source type to another Source Type and use existing steps: https://youtu.be/nwYJgG2hmd0

[shareezsaleem]

Tried, but still it doesn't show the newly added columns. But when I refreshed the preview it shows with an error (unexpected error). I loaded the data but it doesn't take the whole value.

I don't understand this error, the column showing error can be seen in power bi once uploaded but without full value.