Webservice Odata Wizard Filter and Fields

(0) Share

Report

Posted on by Mathias Andersen

Dear Community,

I want to create a new Odata Web Service in Business Central, using an existing page where i select specific fields and records to include.

When i use the Wizard named "Reporting Data Setup" from the Web Services page create the new Web Service, i do get the option to select specific fields and add filters.

But when i import the data to e.g. Power BI, i get all the items and all the fields, so my selected fields and filters are not respected.

Do you know whether i am missing something or is it a bug in Business Central.

Thanks in advance.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Steven Renders 5,672 Moderator on at

Like (1)

Report

It's a bug. As long as I know the filters and field selection never worked and it returns all fields and rows :-)

I think this feature might disappear, because when you create a new BC tenant, it usually is not in the assisted setup anymore, however you can still run the wizard manually.

Personally, I think it's better to develop your own APIs/webservices for Power BI, based on Query objects, with aggregations/filters and a column selection. Less is always better in Power BI ;-)

Was this reply helpful? Yes No