Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ayyappa5678
Helper III
Helper III

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

Ayyappa5678_0-1702535824367.png

 

1 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.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

5 REPLIES 5
Idrissshatila
Super User
Super User

Hello @Ayyappa5678 ,

 

try converting it to a matrix.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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.

@Ayyappa5678 ,

 

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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

@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.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.