Countrows in Report Server -Direct Query Mode

[PriyankaA905]

Hi, we encountered with the following error while using the balance bucket formula:

Bal_Bucket =

CALCULATE(DISTINCTCOUNT('MISREP.UTK_T_LIAB_AVG_BAL_NEW'[IACLINK_ACTUAL_ACNUM]),

FILTER( VALUES('MISREP.UTK_T_LIAB_AVG_BAL_NEW'[CURRENT_BALANCE_ASON]),

COUNTROWS(

FILTER(Bucket,

'MISREP.UTK_T_LIAB_AVG_BAL_NEW'[CURRENT_BALANCE_ASON]>= Bucket[MIN]

&& 'MISREP.UTK_T_LIAB_AVG_BAL_NEW'[CURRENT_BALANCE_ASON]<Bucket[MAX]))

> 0))

Also we discovered that there is no option as "Allow unrestricted measures in DirectQuery mode" in Report Server.

What is the solution for the above problem?

[v-luwang-msft · Accepted solution]

Hi @PriyankaA905 ,

I also could not find it on Power BI Desktop not for version.According to the responses in other threads, that option was modified in 2018. Refer:https://community.powerbi.com/t5/Desktop/What-Happened-To-quot-Allow-unrestricted-measures-in-Direct...  

In addition, this feature is not used to break the 1-million-row limit in Direct Query, but rather the one-million-row limit for returning data when using DirectQuery still exists for the limitations are placed on DAX expressions allowed in measures, as you can see here：

https://www.eugenechiang.com/2019/07/11/power-bi-import-vs-directquery/ 

version:

Can you find this function in your Desktop?

In addition, the function is not described in the official article.refer：

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery 

Best Regards

Lucien