Forum Discussion
Sujit_Thakur
6 years agoSolution Sage
Data format change
Dear friends, I have made a report using two Excel files , using merge files from folder option from Power querry. Now the guy which sends me data is saying that from Tommorow he will send me data i...
- 6 years ago
It should work if both of the below conditions are satisfying
- If you haven't applied any file type filter
- If your CSV file schema (Sheet name, column headers ) remains the same.
If possible, try to convert your existing excel file and verify the scenario.
Pragati11
6 years agoSuper User
HI Sujit_Thakur ,
You can combine a excel file and csv file in Power BI if they have same structure, same number of columns, same column names.
Thanks,
Pragati