Data source error - We cannot convert the value "[Table]" to type Table.. IDataReader

Hi Qiuyun

Thank you for considering this issue.

The file originally had SharePoint and local folder as sources and refreshed fine in PBI Service using data gateway.

To remove need for local gateway, I moved the Excel file from local folder to OneDrive. PBI Service could then connect directly with sources. However, this is when Service began returning this error upon dataset refresh attempts.

I downloaded the original file and refresh worked fine in PBI Desktop. No issues with table Sales Funnel.

It may be a data privacy issue as noted by jdunmall here:

http://community.powerbi.com/t5/Service/Data-Privacy-Broken-We-cannot-convert-the-value-quot-Record-quot/m-p/39295/highlight/true#M9142

Suspecting this, I moved the Excel file in OneDrive to the same SharePoint site, thinking there should be no privacy issue since now all source files are in same source, and yes refresh worked in PBI Service. This increases my belief that it is a data privacy issue in the Service.

Thanks

Mohammed