Hi,
I`m connecting to a table of >2M rows through direct query and using a single column on there to create a measure with the percentile function.
I`m being hit with the 1M row limit although creating other measures (Sum or Divide functions, or auto-aggregations from PowerBI such as sum, count, countD, average) are all working fine.
Percentile measure is created from a single table that is not connected to my other tables, all my tables come from the same DB.
UPDATE: I am not visualising all rows or all columns values themselves anywhere on the dashbaord
UPDATE: seems like percentile is not a function support in Direct Query, any idea how to replicate it in other terms?
Would anybody be able to offer insights or workarounds?
Many thanks,
