ODATA: filtering the access to a dataset

Slimani Member
edited December 2023 in General

Hello dear community,

Our use case is as follow:

We will have a big dataset and we would like to get access into it using Odata, but we are not interested in the hole dataset, only a small part.

Is it possible to apply a filter when we get access to a dataset using Odata

Thank you in advance

Best Answer

  • Josh Boxer
    Josh Boxer Administrator
    Answer ✓

    Hi Ali

    It is not possible to filter operator when using OData, but I have added your vote to the request.

    If you are loading the data into Excel or PowerBI then PowerQuery will let you apply filters before the dataset is loaded/refreshed.