Forum Discussion
Assimilating text data from multiple workbooks
I created a work sheet with 15 questions. I presented the questionnaire to 20 people. I now want to create a worksheet with the correlated information in progressive order.
Question 1:
Response 1
Response 2
etc...
Question 2
Response 1
etc..etc..
Help
Hi RhinoBane ,
You can put these excel files into the same folder, and go to Power BI Desktop, click Get Data-> Folder. You can directly combine them. Please refer to
Combine files (binaries) in Power BI Desktop - Power BI | Microsoft Learn
Or try to shape and combine data in Power Query after data is imported. Please refer to
Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
Hi RhinoBane ,
You can put these excel files into the same folder, and go to Power BI Desktop, click Get Data-> Folder. You can directly combine them. Please refer to
Combine files (binaries) in Power BI Desktop - Power BI | Microsoft Learn
Or try to shape and combine data in Power Query after data is imported. Please refer to
Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly