Forum Discussion

Helper IV

5 years ago

Get authorization token from API url

How can I get the authorization token value? I'm using advanced editor in power BI desktop. I do have the generating token URL also the credentials (user and password). let GetJson = Web.Conten...

Helper IV

5 years ago

Hi amitchandak I saw this but it is using client id instead of username/password 😞

Super User

5 years ago

ImkeF , any suggestions on this

ImkeF
Community Champion
5 years ago
Hi gilbertendaya ,

if you're trying to create an oauth flow in Power Query, you need to create a custom connetor, I'm afraid.
You can find some details on the auth-part here: https://docs.microsoft.com/en-us/power-query/handlingauthentication

This gives a good overview of the steps involved to create a custom connector: https://jussiroine.com/2019/02/building-a-custom-connector-for-power-bi-that-supports-oauth2-to-visualize-my-wellness-data/
- gilbertendaya
  Helper IV
  5 years ago
  hi ImkeF thank you for the reply. Is there no easy way in M-query to do this?
  - gilbertendaya
    Helper IV
    5 years ago
    hi ImkeF and amitchandak
    do you know how to convert this to M-query?
    
    {
        "limit": 10,
        "aggregate": [
            {
                "$sort": {
                    "dateProcessed": -1
                }
            },
            {
                "$match": {
    
                }
            }
        ]
    }
    
    This is for the body.