Forum Discussion

MFalk118's avatar
MFalk118
Frequent Visitor
2 years ago

OAuth Authentication in Power Query M

I have a query like this: let headers = [#"Prefer" = "odata.maxpagesize=10000" ], updatedHeaders = Record.Combine({headers,GetOAuthHeader()}), Source = Web.Contents("https://devnst.visionpeople...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi MFalk118 

 

It looks weird if it works in the service but fails in Desktop. Do you see any error when you try to refresh the data in Desktop? If you create a blank report and connect to the same data source with the same query, will it get the data successfully?

 

If GetOAuthHeader() is a custom function to get a Bearer token, can you test it individually to check whether it can return a Bearer token successfully?

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!