topic Re: Query option 'SkipToken' is not allowed (Microsoft Graph connection) in Power Query

Query option 'SkipToken' is not allowed (Microsoft Graph connection)

vanya_val — Wed, 03 Feb 2021 09:42:11 GMT

I have a report which uses Microsoft Teams (Shifts) as a datasource. I was able to connect to and refresh the data source fine for months. Now suddenly it's giving me this error whenever I try to refresh:

DataSource.Error: OData: Request failed: The remote server returned an error: (400) Bad Request. (The query specified in the URI is not valid. Query option 'SkipToken' is not allowed. To allow it, set the 'AllowedQueryOptions' property on EnableQueryAttribute or QueryValidationSettings.)

Does anyone know how to fix this please?

Re: Query option 'SkipToken' is not allowed (Microsoft Graph connection)

v-alq-msft — Fri, 05 Feb 2021 02:45:35 GMT

Hi, vanya_val

About connecting Power BI to Microsoft Graph, you may refer to the following article to see if it helps.

https://tech-peanuts.com/2020/05/28/connecting-power-bi-to-microsoft-graph/

Best Regards

Allan

Re: Query option 'SkipToken' is not allowed (Microsoft Graph connection)

vanya_val — Thu, 18 Feb 2021 08:53:55 GMT

Thanks for your reply. I was hoping that there would be a more straight-forward way as I'm not very technical and have never used Azure but I'll give this a go!