cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dilshan_17
Frequent Visitor

Enhance the performance of Large Power BI report

Hi All,

Currently, I am working with a Larger report (451Mb) and my current data sources are as below.

 

Data set 

      No of file

          File type

          Location

 

Sales Data Sub 01

        24 File

              CSV                          

         Data Lake

Combine in BI

Sales Data Sub 02

        24 File

              CSV

         Data Lake

Combine in BI

Supporting table 01

        01

               xls

         One drive

-

Sub data sets

        12 files

 

         Azure DB

Not combine

 

The report’s performance is currently good, and I need to add new measures and visuals to the same report. My doubt is when I add more measures and visuals it is going to affect the performance of the report. How can I improve the performance of the report when it comes to a large number of calculations?

 

If I add Sales data sub 01 and Sales data sub 02 data(two types of subsidiary’s sales data) into the Azure DB as two tables and get the data from there will it increase the performance of the report?

1 REPLY 1
v-jayw-msft
Community Support
Community Support

Hi @dilshan_17 ,

 

What connect mode you are using? Using Direct Query mode may have better performance than using import mode when the dataset is large. 

 

Best Regards,

Jay

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors