Forum Discussion
Improve Performance
Hi all, I`ve been using PBI for around 3 years but learned mostly online, so still learning about best practices. I`m having a small issue because I`m pulling raw data from a server that I have r...
Hello Anonymous ,
well, its better to do the work in power query rather than doing it as calculated columns or calculated tables.
try grouping by if you could, this would make the data smaller.
try implementing incremental refresh thus it won't refresh all data every time, just a range of date that you choose.
I tried doing as well, some of those are fine. For Lookup specifically have to merge tables and I was told that this is taking a lot from the servers as well. That`s why I`m looking for other options in case this not being enough. It seems that file size it`s not the issue but how much processing the file is taking.