Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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
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