Forum Discussion
YasirKazi77
5 years agoFrequent Visitor
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.
1 Reply
- amitchandakSuper User
YasirKazi77 , refer if these past solution can help(similar not excat)
https://community.powerbi.com/t5/Power-Query/Power-Query-API-Source-dynamic-token/td-p/983710
or