Schedule refresh error at Workspace but no error with local PC refresh

[kennykhor]

My report hosted in Power BI webspace hit error today and keep prompting "Type mismatch" for a particular table loaded from Excel file. I have no problem to refresh this same table in my local PC, however the workspace copy is hitting error, which was working fine earlier.

Can someone please shed light on how to determine the root cause? Since no error arising from the report when refresh in local PC. For info, the Excel file is stored in sharepoint, both workspace and local copy are refreshing from the Excel file in the sharepoint.

[arvindsingh802]

Please confirm  Privacy level of your data source, update the web privacy level same as your desktop file and you should be good.

[kennykhor]

Hi, I just checked, both are set to "Organizational". For info, the data refresh is working fine till yesterday, and there is no change on it recently.

[arvindsingh802 · Accepted solution]

Oh, then it would be possible, your source file column datatype have been updated
Try this, refresh it on desktop and publish that file on service replacing existing one

[kennykhor]

I added a "Change Type" step, and notice there're some errors indicated on the pre-determined date columns. After standardized the date value, manage to refresh the schedule without error now. Thanks for valuable advice.

[arvindsingh802]

Great, please accept the applicable answer as solution to help others in future.