Hi all,
Anyone familiar with the Microsoft M language, aka Power Query, which runs the back end data pulls in Excel and Power BI?
I’m no novice, but I’m struggling to write M code to work through the OAuth Flow, and have spent the last 2 hours searching the internet, to no avail.
Hoping for some help here.
A quick search in the docs and I found this: https://docs.microsoft.com/en-us/powerquery-m/web-contents
That should be enough for implementing a very basic OAuth2 client credentials flow. The authorization code flow can be a lot more difficult (if possible at all).
If you don’t want to implement the whole OAuth2 handlers you might take advantage of this project to only implement simple GET requests to pull the data (plus keeping your credentials safe and out of your M code).