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

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-Failed/td-p/852295

Thanks for your time,

Regards,

Pkasa