Webinar recording
Power BI Performance Optimization: How to make your reports run up to 10x faster?

What can you do to speed up your Power BI reports and improve the experience for your end-users?

Watch this webinar to learn how to diagnose your report performance and see what steps to take to speed it up to achieve perfectly responsive Power BI reports.

What's included

Full video recording
Performace Checklist - PDF
Enjoy & thank you for watching! Don't hesitate to reach out if you have any questions — write to us at support@zebrabi.com!

Presenter

Andrej Lapajne

Founder & CEO at Zebra BI

Watch the Video

Performance Optimization Checklist
A list of actionable tips for optimizing performance for Power BI reports. How to make them run up to 10x faster.
Access the materials
00:00:05 Intro
00:03:05 Analyzing the performance
00:17:25 Data model
00:46:35 Reports and visuals
00:56:39 Wrap Up: Performance checklist
01:01:00 Q&A session
Share this

Your Questions

Here are some of the questions that came up during our live session. Thank you for being such a proactive audience. Have more questions? Drop us a note at support@zebrabi.com!
When you say "filter out" any columns that will not be used, should we just try to hide the columns in the BI desktop or should we try to remove the columns from the source data?

You can remove them either in Power Query or on the source itself. The main message is to keep the tables lean. Ask yourself this question: "Will I need this column in the report?" - If YES, keep it, if the answer is NO, remove it from the query.

Is there a difference between prepping data in Power Query or using an external program then uploading clean data to Power BI afterwards?

Both options should perform well, If the external program then stores the data in SSAS (SQL Server or Azure Analysis Services) database and you are using a Live connection to that source you are using the same Tabular Vertipaq storage engine as Power BI on import.

Why is consolidated visual so much faster compared to seperate visuals?

1 visual = 1 query + 1 visual loading time. More visuals multiplies that. Even if you can leverege parallel loading it has to do it for every visual.

I watched a video on using performance analyzer and they recommended to start on a blank page, record, then go to the page in question due to caching. Does the refresh visuals button diregard cache or should we start from a different page first, record, then switch to the page in question?

Yes, this is the best approach when recording initial load (first and longest load). Start from a blank page, save the report and re-open it. Else PBI will help itself with the cache. Refresh visuals and all subsequent refreshes get help from cache.

Prefer written step-by-step instructions?

Read the Article

Ready to start uncovering actionable insights from your data?

Explore Zebra BI for Office and Power BI, or start a trial instantly and test our tools on your data. You can also contact us to help you build your first test report and create a custom package for your business.

More Trending Webinars

November 27, 2024
The New Era of Business Intelligence: AI-Powered Business Decision-Making
Artificial Intelligence is transforming Business Intelligence and data analysis, offering powerful tools for data-driven decision-making. But where does AI fall short, and how can we bridge these gaps to maximize its potential?
Watch now
December 5, 2024
How to Make Power BI Dashboards Actionable and Drive Better Decisions 
Power BI can be a true game-changer for organizations looking to turn their data into actionable insights. But how do you leverage it to achieve its max potential -- and how do you make handling dashboards easier, more user-friendly, and more efficient? Join our FREE webinar and find out!
Watch now
New
September 12, 2024
Master Cost Management: Elevate Reporting, Tracking, and Efficiency
Master cost management with Zebra BI. Discover advanced techniques to optimize financial reporting, enhance budgeting accuracy, and make smarter, data-driven business decisions for long-term success.
Watch now
May 23, 2024
Mastering Brand and Product Portfolio Analysis in Power BI
Unlock the power of product portfolio analysis with Zebra BI in Power BI. Learn to visualize and analyze product performance, identify growth opportunities, and drive strategic business decisions with data-driven insights.
Watch now
April 18, 2024
Commentary Revolution: Transforming Power BI Dashboards with Dynamic Comments
Join our webinar to explore the easiest way so far to do dynamic commentary in Power BI for clearer insights, quicker decisions, and smoother meetings.
Watch now
Browse All Resources