refresh error: validation error

[nerdyplayer]

[ValidateMarkupTags][ccon]Expression.Error: We cannot convert the value [ccon]"[List]"[/ccon] to type Table.. [/ccon]. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.

the dashboard was working fine until monday. The source is an excel spreadsheet in a sharepoint library.

I refresh the dashboard in the desktop client and had no issues. its only when it is on the site that the refresh fairs.

Checked the table, don't see anything out of the ordinary, column types are correct. values are what i expect to see. Not sure what's going on.

[Idrissshatila]

HEllo @nerdyplayer ,

try opening the Power query and refresh the tables inside it to see where is the error coming from.

[nerdyplayer]

I did that. nothing pops up. no error shows up when refreshing the data set.

the error only happens when it tries to refresh on the site.