Forum Discussion

rpboyer2's avatar
rpboyer2
Frequent Visitor
3 years ago

PowerBI REST API & Access Token with Power Query

Greetings, I'm looking for some input regarding obtaining data from the PowerBI REST API with a function to automate Access Token generation. I can get data from the API with Power Query using the f...
Need Help
FionaE's avatar
FionaE
Regular Visitor
3 years ago

Hi

I followed the exact same process but I cannot even get the get access token function to work. My GET Access Token code is exactly the same as yours, but with my own credentials. It just comes up with this message when I click done.

 

Any help would be greatly appreciated.

rpboyer2 ams1 

  • rpboyer2's avatar
    rpboyer2
    Frequent Visitor
    3 years ago

    I was able to get past this issue with the help of Microsoft Support. My apologies i havent been able to share the solution in full detail with the community. I've been swamped in both my work and personal life. Contacting Microsoft Support is what i would recommend. Also i can offer to forward you my email chain of discourse with them which might help contextually how i was able to resolve the issue.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      hey, I'm running into the same issue, but I'm trying to get Power Automate to generate the token, so that I can run some automations through that way. The access token that I'm generating is significantly shorter than the one generated by the Rest API Try It feature.

      Can you email me that same thread from Microsoft Support?

      [email protected]

    • dospencer's avatar
      dospencer
      Frequent Visitor
      3 years ago

      Hi,

       

      I'm having the same issues and would appreciate if you could forward the email exchange you had with MS Support. Please send to [email protected].