Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
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.
@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