Query contains unsupported function. Function name: SharePoint.Tables

[tony-G_2020]

Hi

I'm trying to enable auto-refresh in the Power BI services without any luck.   I can manually refresh the dataset on Power BI desktop but not in  PowerBI services. 

I this in the error when I refreshed in Power BI services.  

Query contains unsupported function. Function name: SharePoint.Tables

Any suggestions or help would be much appreciated. thank you

[Anonymous]

Hi @tony-G_2020,

In fact, some of power query functions not really released into the common power query functions list.
I think they are preview packs of some tricks or features that use to handle specific scenarios. (they do not release to common version, so that power bi service M query can't recognize these functions) 

In my opinion, I'd like to suggest you vote these functions to increase the priority of release.

Regards,

Xiaoxin Sheng