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

Hi mmuddasar,

Did this dataset can be refreshed successfully before in Power BI service? 

Did you modify the report recently? 

Please download the report and open in desktop, check if any error occurs in Table: Sales Funnel. 

Best Regards,
Qiuyun Yu 

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

Hello together, 

for me it worked, as soon as I changed Privacy Level to Organisation for all my sources. This error takes place when you are trying to join data sources that have different Security Levels. 

Changing all to Organisation solved the issue. 

I hope it will help someone. 

Thanks

Magomed.

Same for me - changing the Privacy levels on all data sources to Organisational fixed this.   This page was a lifesaver.

( I like how the error message played no part in understanding or fixing the issue ... it might as well have said - " error : purple , monkey, dishwasher" )