No 37: Marco Russo: My Power BI report is slow: what should I do?

This is a past event

150 people went

What we'll do

Meetup Agenda

• 5:45pm - Arrive, meet & greet, drinks
• 6:10pm - Welcome & intro - Greg Nash
• 6:15pm - Presentation
• 7:15pm - Wrap up

My Power BI report is slow: what should I do?

You created a wonderful Power BI report, but when you open it you wait too much time. Changing a slicer selection is also slow. Where should you start analyzing the problem? What can you do to optimize performance?

This session will guide you in analyzing the possible reasons for a slow Power BI report. By using Power BI Performance Analyzer and DAX Studio, you will be able to determine whether you should change the report layout, or if there is something in DAX formulas or in the data model that is responsible for the slow response.

At the end of this session, you will understand how to locate a performance bottleneck in a Power BI report, so you will focus your attention on the biggest issue.

About Marco

A veteran of end-to-end projects, Marco wrote several books with Alberto Ferrari about Power BI, Analysis Service, and Power Pivot. They also regularly write articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services.

Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide.

Marco is a regular speaker at international conferences like Microsoft Ignite, PASS Summit, and Sqlbits. He also enjoys delivering evening sessions at local user groups during his trips.

When he is not working, you can find Marco fine tuning his expertise of Neapolitan pizza or test driving electric cars.

Our Sponsor - Servian Pty Ltd (http://www.servian.com/)

A big thank you goes out to our sponsor, Servian, for their support of this Meetup; providing the venue as well as drinks for attendees.

Servian is regarded as one of Australia’s most trusted data consultancies and IT advisors. Major organisations have come to rely on our thought leadership on Data Integration, Analytics, Data Warehousing, Application Development as well as the value we provide in support and maintenance.

Servian has a proven track record in delivering tailored programs, technological processes and specialist advice that boost business capabilities, operational performance, internal processes, customer service, stakeholder communication and much more.

Servian is always on the lookout for talented individuals. If you think you'd be a fit for Servian, get in touch.

Sirius Technology (https://www.siriuspeople.com.au/)

A big thank also to our co-sponsor, Sirius Technology, for their ongoing support of our Meetup and providing us with food for each event.

Sirius Technology recruit across all Technology Disciplines from Development (Front and back-end), Testing, Network and Security, Project Services (PM's, BA's, Project Coordinators) & Data - across all technology stacks.

Donna Bowen (https://www.linkedin.com/in/donna-bowen-b2a80179) will be on hand to answer any questions about the industry and recruits specifically within the Business Intelligence and Data space. Anything from Data Scientists, Data Analysts, Business Intelligence Consultants, ETL Developers, Database Administrators etc. across all technology stacks.