Visma.net journal balances not retrievable

[forums]

periodId is not a column, but a parameter and therefore GeneralLedgerBalancesV2 is a so-called "table function. Table functions can not be addressed from Power BI, since to our knowledge it’s OData-driver does not support these.

For more information on using table functions in general see:

What are table functions and table function parameters?

Go to Dutch version In this topic you will learn what table functions and table function parameters are and how they are applied within Invantive SQL. In the SQL grammar you can find more information about the concepts behind Invantive SQL. Invantive SQL has three types of tables: tables: a list of rows with data that can be retrieved by providing the name views: a list of rows with data that can be accessed by providing the name Table functions: a list of rows with data that is retrievable …

For Visma.net balances, you might want to try whether the following query provides usable results. If so, please update this topic for possible including of a new view for this purpose in the Visma.net SQL-driver from Invantive for use with Power BI.

select *
from   FinancialPeriods fpd
join   GeneralLedgerBalancesV2(fpd.company_code, fpd.Period)
limit  10