Melissa
December 29, 2019, 9:21am
2
Hi Anu,
Power Automate can be used to trigger a refresh for example not for optimization purposes.
Hi there,
The big thing for me here is that you seem to be doing calculations and summaries in your queries. Personally I would not do this on a large data set because as you’re experiencing it will be very slow.
You should look to simplify what you need from your core Sales table and then do any the calculations using DAX measures. This is the most optimized way to do things in Power BI.
I’m sure you Sales table doesn’t need to be that wide (or have that many columns). It’s just about gettin…
Hi Fredrik,
That’s an excellent question. And you are right the order can matter greatly…
I’ve found some articles by Chris Webb you’ll find interesting. His recommendations, start by removing all unnecessary columns from your tables, especially if you’re doing transformations such as sorts, merges, groupings, pivots or unpivots. And most optimisations the Power Query engine can use only happen on tables – not records or lists – so you should always try to work with tables whenever you can.
F…
.