Regarding, Visual has exceeded the available resources, kindly please help me!

[Ayyappa5678]

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!!

[Idrissshatila]

Hello @Ayyappa5678 ,

try converting it to a matrix.

[Ayyappa5678]

But here having columns info like date, address and around 22 columns details information we want.

while converting to matrix it will showing like date wise data and expanding with all the dates and stuff also getting the same error.
Kindly please help me.

[Idrissshatila]

@Ayyappa5678 ,

that's why its not working, too much load on it, you need to do some grouping.

[Ayyappa5678]

Kindly please suggest, if i spilt dataset into 3-4 tables and do the some relationship with tables then it will work or not?
Kindly please help me

[Idrissshatila · Accepted solution]

@Ayyappa5678 ,

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.