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.
Hi ddbaker ,
As @ edhans mentioned, adding multi queries for each file in power query is inefficient. Since you are using Onedrive, you can try to sotre these files in a folder of Onedrive and connect to Onedrive folder to combine necessary files and load into power bi, refer: Power BI Get Data from Multiple Files in a Folder on OneDrive for Business, No Gateway Needed
In addition, for improving data model performance, you can also refer these documents and viedos that could help you:
- Power Query Performance Optimization
- Optimization guide for Power BI
- Power BI Performance Optimization Tips
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.