cancel
Showing results for 
Search instead for 
Did you mean: 
0

We cannot convert the value "[Table]" to type Table

I'm getting the following error when trying to refresh a data connection within Power BI Service. The data refresehes fine within Power BI Desktop.

Power BI Error.JPG

 

My data connections are SharePoint Lists.

Status: Delivered
Comments
Microsoft

@AJZoerner

 

I cannot repro the same issue with SharePoint Lists data source. Could this dataset be refreshed properly before? If yes, have you tried to delete the dataset in Power BI Service and then publish again from Power BI Desktop?

 

Best Regards,

Herbert

Frequent Visitor

I do not remember the refresh ever working in Power BI service; I believe it has only worked in Power BI Desktop. I just tried deleting the dataset and re-publishing it and am still getting the same error.

Microsoft

@AJZoerner

 

I’m still not able to repro your issue. I suggest you to create a support ticket at http://support.powerbi.com (see bottom of page).

 

Best Regards,

Herbert

Impactful Individual
Status changed to: Delivered
 
Frequent Visitor

Did anyone ever discover a solutiuon to this?

 

I am having the exact same problem.

Frequent Visitor

@cclark01,

 

I believe, for me,  this was fixed with an update of Power BI a few months back.

Helper I

I encountered this problem as soon as I changed from each query pointing to the original source, to each query referencing a single query of the original data source, as recommended here: https://powerpivotpro.com/2017/05/power-query-magic-part-1-always-good-references/

Idea Statuses