Forum Discussion
Solved
Adding New Queries Takes Forever
Hi Everyone, To begin, I'm fairly new to Power BI, and my background is in Finance not Data Science. I recognize that building good models requires proper training and technique, however, I have ...
Hi ddbaker - no, you can do the transformations in Power Query.
- Do the combine operation as normal.
- You will have a large listing of data. That needs to be cleaned up.
- Go to the "Sample Query" that Power Query created as part of the combine operation. From there, do the individual unpivots, renaming, etc. So you are transforming one file there.
- Power Query will then use that logic and apply to every file and drop it in your final combined query.
Thank you for your post edhans. I have the same issue where it takes forever to process any change. Will most surely investigate what you propose.
On the othe hand - ddbaker , my laptop was also running out of RAM because I only had 8Gb of RAM. I upgraded the RAM to 16GB and my computer RAM runs at 50-60% most of the time - problem solved, but it is still taking forever to process changes, hence why I will investigate what ddbaker suggests.
By the way ddbaker , I am also new to Power BI and on a huge learning journey. I give credit to the masters on this forum for sharing - it has certainly help me a lot.