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.
Error:
i am getting this error
details:
i can able to filter a report in desktop for a 6 months but in service i could not able to filter for 2 months
i need to filter this report for 3 months atlest in service need help
i used to be a pro user as it is limited ubgraded to premium user now still i can not able to filter report more then a month.
its a very simple report 2 views from differnt server join in power bi model and display in table
please see screen shorts: need urget guidence or help
Its not sorted , i cant change capacity its a blank , still same issue
Hi @narasimhuluk ,
According to the official Microsoft article description:
The following table summarizes all the limitations that are dependent on the capacity size:
Capacity SKU | Size in vCores | Backend vCores | CPU time / minute | Memory per artifact* [Gb] | Max memory per query* [Gb] | DirectQuery\LC queries / sec * |
---|---|---|---|---|---|---|
A1\EM1 | 1 | 0.5 | 30 | 3 | 1 | 3.75 |
A2\EM2 | 2 | 1 | 60 | 6 | 2 | 7.5 |
A3\EM3 | 4 | 2 | 120 | 10 | 2 | 15 |
A4\P1 | 8 | 4 | 240 | 25 | 6 | 30 |
A5\P2 | 16 | 8 | 480 | 50 | 6 | 60 |
A6\P3 | 32 | 16 | 960 | 100 | 10 | 120 |
Maximize your capacity's available resources by enabling workloads only if they will be used. Change memory and other settings only when you have determined default settings are not meeting your capacity resource requirements.
In Capacity settings > PREMIUM CAPACITIES, select a capacity.
Under MORE OPTIONS, expand Workloads.
Enable one or more workloads, and set a value for Max Memory and other settings.
Select Apply.
Refer:https://blog.crossjoin.co.uk/2020/01/20/visual-has-exceeded-the-available-resources-error-power-bi/
Wish it is helpful for you!
Best Regards
Lucien
I have alrady login with pro powerbi service. but still facing same issue.
my dax measure as mentioned bwllow:
Hi, you need Power BI Premium to do this? Not much I can do in Admin Portal with my Power BI Pro.
JG
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.