Forum Discussion

YasirKazi77's avatar
YasirKazi77
Frequent Visitor
5 years ago

Token Parameter in connection string

Hello,

I have a POwer BI report where I am getting data from LeanKit using an API end point . The API end point requires a token to be added to the request (example attached) . The token is valid for 7 days , so I need to replace it every week. 

I was wondering if there was a way to create a paramter for the connection string and read the token from a text file so that I dont have to modify the connection string every week.

I will only place the new token in the text file and the data "Refresh" process will read the tocken from the text file.