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
Anonymous
Not applicable

Power BI Dashboard Performance

I have built a Power BI dashboard which has 40+ cards, one table, 2 slicers and no visuals. The cards in the dashboard take too long to populate the details when I select a new item/value from the slicers. I know the numbers of cards used in the dasboard are too much but its something my target audtience would like to see in terms of readability. 

Is there a way wherein I can improve the performance of the dashboard so that it does not take too long to poplate the details in the cards once I select a new value from the slicer? Just an FYI the size of my .pbix file is 1MB (If that helps)

2 ACCEPTED SOLUTIONS
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Anonymous ,

It seems that you want to improve the performance of Power BI report.

If you data is very large or you use many complex measure, the performance will be slow.

Please have a good look at the tips below.

power bi reports performance

power bi performance tips and techniques

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

@Anonymous # of visual will surely have impact but it also depends on measure, seems like you don't have any measure used in the report, I guess visuals are the root cause for performance.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

3 REPLIES 3
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Anonymous ,

It seems that you want to improve the performance of Power BI report.

If you data is very large or you use many complex measure, the performance will be slow.

Please have a good look at the tips below.

power bi reports performance

power bi performance tips and techniques

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi @v-piga-msft

Thank you for your response. I am not using any complex measures. Also, the data set I believe is not that large, its 250MB (From a CSV file). I have gone through the links that you mentioned but there wasn't much for me to do in my exisiting file. Does using too many cards detoriate the performance of the dashboard? 

Thanks, 
Jash. 

@Anonymous # of visual will surely have impact but it also depends on measure, seems like you don't have any measure used in the report, I guess visuals are the root cause for performance.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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