Forum Discussion
Solved
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...
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.
Sujit_Thakur , Create an import with csv. Go to Edit Query mode. right click and open advance editor. Copy the source information.
Go and update the same in excel source.
refer