Forum Discussion
Regarding, Visual has exceeded the available resources, kindly please help me!
Hi Team,
Good Morning!
I am getting below error in power bi service. data refresh is running successfully. just i am using only 3 filters and 1 table visuals.
And just importing one table from adls having 102,227,067 rows.
"Visual has exceeded the available resources"
1. Do we split into 2-3 dataset tables and do relationships with that then it will get the visual or not?
2. Any creation of parameters is possible to get the visual in service?
3. Kindly help me with best possible way please!!
Anonymous ,
if you don't need this level of details, take out the data that you don't need or perhaps do some group by in Power query.
5 Replies
- Idrissshatila
Super User
Hello Anonymous ,
try converting it to a matrix.
- Idrissshatila
Anonymous ,
that's why its not working, too much load on it, you need to do some grouping.