Power BI Rest API's as a data source in Power BI report - How to get Dynamic Token ?

[Anonymous]

Hello there, I am trying to use the Power BI Rest API's as a data source in Power BI report for getting some Refresh's data and Scheduled Refreshes  on our workspaces etc.., With the help of  a friedn from Power BI Community (v-lid-msft) I am able to import this information and works in Service as well. However we need to update the Token in the service before every refresh.

I am looking for a way where can can Dynamically get the Token based on the Org account. I saw from the below url by default Microsoft is giving the token based on my login is there a way to import this into Power BI and capture the Token. Look for Request Preview Section in the below url, this will have the token, after sigining into the Org account.

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getrefreshhistoryingroup#code-try-0

Our original Post to get the Failure Refreshes data from Power BI Service.

https://community.powerbi.com/t5/Service/PowerBI-Service-List-of-Power-BI-Reports-Data-set-s-with-Fa...

Thanks for your time,

Regards,

Pkasa

[v-joesh-msft]

Hi @Anonymous ,

After my research, I'm afraid it couldn't achieve in Power BI for now. For your requirement,you can come up with a new idea and add your comments there to make this feature coming sooner. 

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.