Countrows in Report Server -Direct Query Mode

PriyankaA905 — Tue, 03 May 2022 08:04:23 GMT

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?

Re: Countrows in Report Server -Direct Query Mode

v-luwang-msft — Thu, 12 May 2022 07:47:16 GMT

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-DirectQuery/m-p/471719

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

topic Countrows in Report Server -Direct Query Mode in Report Server

Countrows in Report Server -Direct Query Mode

Re: Countrows in Report Server -Direct Query Mode