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 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is 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.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 1 |