To enable Power BI with SpeedAdmin, you will need to purchase access to Lists through our API. Once purchased, you will be issued the API Key that can then be used in the below setup:
- Create a new list in SpeedAdmin and make it global.
- Find the Id of the list in the URL.
- Create an API Key and enable the API feature for Lists on that key.
- Install Power BI
- Follow the video below.
let
Source = Json.Document(Web.Contents("https://api.speedadmin.dk/v1/list/SPEEDADMIN_LIST_ID", [Headers=[Authorization="SPEEDADMIN_API_KEY"]])),
#"Converted to Table" = Table.FromRecords({Source}),
#"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Data", type text}, {"ReportId", Int64.Type}, {"Title", type text}}),
Data1 = Json.Document(#"Changed Type"{0}[Data]),
#"Converted to Table1" = Table.FromList(Data1, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
#"Converted to Table1"