Forum Discussion
Schedule refresh error at Workspace but no error with local PC refresh
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.
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
5 Replies
- arvindsingh802
Community Champion
Please confirm Privacy level of your data source, update the web privacy level same as your desktop file and you should be good.
- kennykhor
Advocate I
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
Community Champion
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