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

[AJZoerner]

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.

My data connections are SharePoint Lists.

[v-haibl-msft]

@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

[AJZoerner]

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.

[v-haibl-msft]

@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

[cclark01]

Did anyone ever discover a solutiuon to this?

I am having the exact same problem.

[AJZoerner]

@cclark01,

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

[mikegunns]

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/