Advanced query for transactions

[Ealfardan]

Hi @Roger_Van_Decraen,

@Roger_Van_Decraen

is ther a way to use the power query tool in Excel or power BI to get the data directly in excel or power BI ?

Absolutely, you can use this connector:

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…

And navigate to path summary-transactions