Add an internal Excel source

[Ealfardan]

The connector is available on this thread

API 2 using Power Query

This is a basic connector to connect Excel (or PowerBI) to Manager api2. let _ExpandCols = (TableToExpand as table, optional ColumnName as text) => let ListAllColumns = Table.ColumnNames(TableToExpand), ColumnsTotal = Table.ColumnCount(TableToExpand), CurrentColumnIndex = if (ColumnName = null) then 0 else List.PositionOf(ListAllColumns, ColumnName), CurrentColumnName = ListAllColumns{CurrentColumnIndex}, CurrentColumnContent = Table.Column(TableToEx…

You can get report views by navigating to its view path, e.g. /balance-sheet-view/{key}

To get all the navigable paths, you can use this power query connector:

let
   Source = "https://{your manager domain}/api2",
   Schema = Json.Document(Web.Contents(Source))
in
   Schema