Forum Discussion

tony-G_2020's avatar
tony-G_2020
Frequent Visitor
6 years ago

Query contains unsupported function. Function name: SharePoint.Tables

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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