Forum Discussion
Countrows in Report Server -Direct Query Mode
Hi, we encountered with the following error while using the balance bucket formula:
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?
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
1 Reply
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