Skip to main content

Power BI

New

ODATA

Vote (6) Share
John Madden's profile image

John Madden on 21 Feb 2018 01:57:22

Support the full suite of DateTime filters such that they all form 'filtered' ODATA queries. Right now some filters create a filtered ODATA quer, for example, using the 'After' query will result in a ODATA filtered url: ?$filter=StartTime gt 201802012T00:00:00-06:00 whereas using the "In the Previous" filter results in a completely unfiltered ODATA query and Power BI apparently filters through the results on the client side.

For a ODATA feed that may contain years worth of data this simply won't work.

Comments (1)
John Madden's profile image Profile Picture

af24a3f1 cd64-4076-83a3-cd64880ac52a on 05 Jul 2020 23:53:57

RE: ODATA

This really is necessary - not only does it mean that the initial data load is far larger than it needs to be when adding in an Odata data source, but configuring the filter client side isn't always realistic when the filter needs to refer to a small sample of the records if none of them are in the preview window.