Enable Add-on with SysAid Storage
- 27 Sep 2023
- 1 Minute to read
- Print
- DarkLight
- PDF
Enable Add-on with SysAid Storage
- Updated on 27 Sep 2023
- 1 Minute to read
- Print
- DarkLight
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
Enable Power BI Add-on with SysAid Storage
Step 1: Click "Select where to save BI data" and choose "SysAid Storage"
Step 2: Click "Save Changes"
Step 3: Enable the "Activate integration" Slider
Step 4: Click "Generate new token"
Step 5: Take note of the Token field's value (it becomes hashed after you exit the form)
Step 6: Replace the following values in the script via copy & paste:
- URL from POWER BI Extract addon
[screenshot from Ionut, hashed account id] - Clientid from POWER BI Extract addon
[screenshot from Ionut, hashed - accountid
- The Token from Power BI Extract addon
[screenshot from Ionut, hashed
let
Source = Table.FromColumns({Lines.FromBinary(Web.Contents("Paste the URL from POWER BI Extract addon", [Headers=[clientid="Clientid from POWER BI Extract addon", accountid="Your SysAid account id", authorization="The Token from Power BI Extract addon"]]))}),
#"Parsed JSON" = Table.TransformColumns(Source,{},Json.Document),
#"JSON to List" = #"Parsed JSON"{0}[Column1],
#"List To SysAid Table List" = Table.FromRecords({#"JSON to List"}),
#"Expanded SysAid" = Table.ExpandListColumn(#"List To SysAid Table List", "SysAid"),
#"Extract Headers" = Record.FieldNames(#"Expanded SysAid"[SysAid]{0}),
#"Merge Data To Table" = Table.ExpandRecordColumn(#"Expanded SysAid", "SysAid", #"Extract Headers")
in
#"Merge Data To Table"
Was this article helpful?
.png)