Forum Discussion

KarenL7's avatar
KarenL7
Icon for Advocate V rankAdvocate V
3 years ago
Solved

Refreshable Token for Power Bi Desktop

Hi   I have seen a lot of posts on here for this - and have been trying a number of them to get this working in PowerBIDesktop.  So far only one seems to be working in my report - FYI I used this p...
Need Help
KarenL7's avatar
KarenL7
Icon for Advocate V rankAdvocate V
3 years ago

Further to my post above -  I have now found out the following -

 

When using this had the error message -

 

 

I requested the access token elsewhere using different credentials and put it directly into my query to see if I could get any results and it worked straight away.

 

My question now is -

 

I can retrieve the token directly without any issues.

I have put this in a function which I call from another query

It then errors saying it is forbidden when trying to access a specific API website.

 

However using my admin credentials and not the ones that client app id etc. and add in the token directly the query works correctly.

 

Are there some permission issues that we need to change for this to work?

 

Thanks

 

Karen