Connect to Power BI

[Ealfardan]

API 2 using Power Query

This is a basic connector to connect Excel (or PowerBI) to Manager api2. let _GetFieldNames = (list) => let allRecords = List.Select(list, each _ is record), isEmpty = List.IsEmpty(List.Distinct(allRecords)), allFieldNames = List.Union(List.Transform(allRecords, each Record.FieldNames(_))), uniqueFieldNames = List.Distinct(allFieldNames) in if isEmpty then {} else uniqueFieldNames, _ExpandCols = (#"Table to Expand" as table, optional #"Co…

This should work for Power BI as well