Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |