AFAS connector via Power BI OData 404 error

[lrs4]

I’m trying to setup the connection from Afas Profit 6 to Power BI, using the OData connector from Invantive.

I’ve configured a connector in Afas with the following setup in AFAS:

General

Get Connectors

User Token

So defined the GetConnectors and added myself as a user and there are no IP restrictions setup yet.

After loading the data with the following query:

let
    Source = OData.Feed("https://bridge-online.invantive.com/MY_SEGMENT/odata4/", null, [Implementation="2.0"])
in
    Source

I can see all the get connectors like GetConnector.profitgetconnectoren@aon.

When I try to modify load a specific data table like this and I get the 404 error:

let
    Source = OData.Feed("https://bridge-online.invantive.com/MY_SEGMENT/odata4/AfasOnline.GetConnector.Profit_Employees@aon", null, [Implementation="2.0"])
in
    Source

How should I get the data from AFAS Profit 6 into Power BI?

[forums]

To be sure: does it concern AFAS Profit version 6 or AFAS Profit version 16? It looks more like a recent version like 16.

In general: the typical step is to download the OData metadata using OData.Feed and then using a filter.

Best is to add a new data set using “Recent sources” and select a table. Then check the Power Query M code for the correct logic.

[lrs4]

While logging in it mentions Profit 5, I’m not very familiair with AFAS though.

Can you provide an example of the Power Query M code? With recent sources, there are no connections available with Afas.

[forums]

The Power Query M code generated for any platform with Invantive Bridge Online using OData4 will be identical. It is recommended to take any existing report.

[lrs4]

Where can I find the existing report?

[forums]

Any existing report will suffice that links to any Invantive database on Invantive Cloud. The Power Query editor should be like:

let
    Source = OData.Feed("https://bridge-online.invantive.com/acme-dummy/odata4", null, [Implementation="2.0"]),
    #"Dummy.Demo.Projects@dmy_table" = Source{[Name="Dummy.Demo.Projects@dmy",Signature="table"]}[Data]
in
    #"Dummy.Demo.Projects@dmy_table"

Note the additional step which filters source for the table name.

Result: