Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
5 | |
4 | |
3 | |
3 |
User | Count |
---|---|
13 | |
10 | |
7 | |
3 | |
3 |