Limit 1M rows on Direct Query in a measure although working fine for other measures

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,