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

Data Overload (Optimize data loading while applying changes/refreshing)

 Hey!

 

I'm loading a file into my PBI Report and making some changes over it. Somehow the file "size" is increased 1000x when I update my data. 

Yet I'm doing some Merges with this table, but nothing too complex.

I'm getting a columns with Versions (actually it's only 4 rows) from this table and using them to expand another table.

Does someone knows why this is happening? Is there a way to optimize this? It's taking quite a bit of time to apply any kind of changes in those tables.

1.png

 

 

2.pngSem título.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
v-huizhn-msft Super Contributor
Super Contributor

Re: Data Overload (Optimize data loading while applying changes/refreshing)

Hi @cfzini,

First, you can filter your resouce data and jut upload necessary data, please refer to this article: Power BI Performance Tips and Techniques.

Second, you use reference query from your screenshot, right? If it is, Please add Table.Buffer in your original Query, when you refresh your reference, which wouldn't access the database again based on my test in this thread

In addtion, there are some following useful threads for your reference.

How to Improve Query Reference performance for large tables 
Improving Power Query Calculation Performance With List.Buffer()
Performance Impact with Calculated Columns

Best Regards,
Angelia

2 REPLIES 2
Highlighted
v-huizhn-msft Super Contributor
Super Contributor

Re: Data Overload (Optimize data loading while applying changes/refreshing)

Hi @cfzini,

First, you can filter your resouce data and jut upload necessary data, please refer to this article: Power BI Performance Tips and Techniques.

Second, you use reference query from your screenshot, right? If it is, Please add Table.Buffer in your original Query, when you refresh your reference, which wouldn't access the database again based on my test in this thread

In addtion, there are some following useful threads for your reference.

How to Improve Query Reference performance for large tables 
Improving Power Query Calculation Performance With List.Buffer()
Performance Impact with Calculated Columns

Best Regards,
Angelia

cfzini Frequent Visitor
Frequent Visitor

Re: Data Overload (Optimize data loading while applying changes/refreshing)

Thank you very much! I've heard about table.buffer already but I never tried!
I don't have access to the company's server yet, but as soon as I have I'll try it and post the result here 😃

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 203 members 2,384 guests
Please welcome our newest community members: