Forum Discussion
Power Bi desktop with large data set
Anonymous when you working with large tables, I always recommend adding a parameter in PQ, let's call it "Number of Rows" and use some value let's say 1000, and then in your table add a below step which will only load the number of rows based on the value in the parameter, it will speed up the development process, and once everything is working as expected, publish the report and in the Power BI service, change the parameter value to 0 which will load all the rows.
= Table.FirstN(#"Changed Type", if #"Number of Rows" = 0 then each true else #"Number of Rows")
So basically when you are developing, you are not FULL ROWS (5 mil).
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
That is very useful, but i do need to load the full table for reconcilation purposes. When i build the formula's that do the reconcilation, it takes very long due to the full table but it is a neccesary step before i can implement the limit row factor.