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.
I need to give someone advice on improving performance on Power BI desktop. This is what comes to mind, is there anything you would add to this?
1. Only using data that you need rather than bringing all the data in
2. Applying appropriate data types
3. Cleaning the data as much as you can removing anything that is redundant or repeated.
4. If you are using an imported model, conforming the data as much as possible to get as much as compression as you can
5. Having a minimum of 8gb memory, 64bit and i5 machine.
6. Clearing the cache in Power BI
7. If you pulling from SQL make sure you are using query folding.
Proud to be a Super User!
Solved! Go to Solution.
Two other tips (mostly) unrelated to the relationship thing:
Proud to be a Super User!
I would add optimizing your data model relationships to prevent unnecessary cross-filtering.
in other words leave it on single directon vs both direction?
Proud to be a Super User!
Correct, if appropriate obviously.
Good topic 🙂
With regards to load-time, disabling background refresh and appropriate buffering will also improve performance significantly: https://blog.crossjoin.co.uk/2016/12/05/power-query-power-bi-and-the-allow-data-preview-to-download-...
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Also if you're working with large amounts of data, you can save precious waiting time during your design-process by using this technique: http://www.thebiccountant.com/2016/11/08/speed-powerbi-power-query-design-process/
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
those are great, thank you!
Proud to be a Super User!
Leave it on single unless you need both. You can always use the CROSSFILTER function to force a "both" directionality. But also make sure that you only create active relationships where you have to, and try to avoid making relationships that require multi-table jumps to complete a measure.
Basically the more your relationship view looks like a simple printed circuitboard, and the less it looks like a large plate of spaghetti, the better.
Proud to be a Super User!
Two other tips (mostly) unrelated to the relationship thing:
Proud to be a Super User!
thanks those are great.
Proud to be a Super User!
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |