Forum Discussion
Helper IVcombine and merge data
im trying to combine data from my local folder and it is xlsx file and structure is same.so i need to combine january xlsx files Jan 1 to Jan 31st.so i tried to do so but it allows only two files and is it possible to combine the existing files inside january folder and then create a power BI report. kindly advise
Hi bzeeblitz
It will be possible by using combine& Transofrm or Combine & load options while loading your data to Power BI. If you see below example.
Step1: If you see I loaded all my files and selected Combined& Transformed data.
Step2: Now if you see all my 9 tables combined and merged as single master table.
Step3: Now if you click on close and apply the data will be loaded to to your PBI desktop.
Additional Tips:
Make sure that the data which is having in your excel sheet should be in Table format. Otherwise you will get error.If you need additional info pls go through this Combine files overview - Power Query | Microsoft Learn, Power Query Folder connector - Power Query | Microsoft Learn
Attching pbix file for your reference.
Thanks!
2 Replies
- suparnababu8
Super User
Hi bzeeblitz
It will be possible by using combine& Transofrm or Combine & load options while loading your data to Power BI. If you see below example.
Step1: If you see I loaded all my files and selected Combined& Transformed data.
Step2: Now if you see all my 9 tables combined and merged as single master table.
Step3: Now if you click on close and apply the data will be loaded to to your PBI desktop.
Additional Tips:
Make sure that the data which is having in your excel sheet should be in Table format. Otherwise you will get error.If you need additional info pls go through this Combine files overview - Power Query | Microsoft Learn, Power Query Folder connector - Power Query | Microsoft Learn
Attching pbix file for your reference.
Thanks!
