Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
I need to provide a valid sessionid to an API's endpoint.
Towards this end, I created a function:
// script-level variable
Session = null;
// if Session doesn't exist or has expired, generate a new one
GetSession = () as record =>
if Session=null or DateTimeZone.LocalNow > Session[expires] then
() =>
let
// get session from API
Response = Xml.Tables(Web.Contents(...)),
// transform response
...
// assign data to script-level variable
Session = [
expires = DateTimeZone.FromText(data[expires]),
sessionid = data[sessionid]
]
in
// return
Session
else
// use existing
Session
;
Unfortunately, the function doesn't work as expected.
What is the recommended way to save a variable's state?
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Check out the July 2026 Power BI update to learn about new features.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |