Forum Discussion
Helper ICriar nova tabela
Tenho uma tabela que é carrega diariamente, sendo que no final do mês os arquivos são excluidos.
Tem como criar uma tabela com onde posso consolidar todas os dados arquivos que são excluidos?
Hi, sns1996
When you need to merge daily loaded data files into one table and delete these files at the end of the month. You can use the "Combine Files" feature in Power Query Editor to combine multiple files with the same pattern into a logical table. Here are the steps on how to do it:
1. Open Power BI Desktop.
2. Select Get Data.3. Select File > Folder.
4. Enter the path to the folder containing the files you want to merge and select Connect.5.In Power Query Editor, you will see all the files in the folder.
6. Select Content (first column of labels), then select Home > Combine files. You can also directly select the Merge Files icon.Merging files behaves as follows:
It analyzes each input file to determine the correct file format to use, such as text, Excel workbook, or JSON file. You can select specific objects (such as an Excel workbook) from the first file to extract.
It automatically does the following:
1. Create a sample query to perform all required extraction steps in a single file.
2. Create a function query that parameterizes the file/binary input into the example query. Sample queries and function queries are related to each other, so changes to the sample query are reflected in the function query.
Applies a function query to the input binary of the original query, such as a folder query. It applies a function query on binary input to each row and then expands the resulting data extract into top-level columns.
3. Using the merge files behavior you can easily merge all the files in a given folder into one table if the files have the same file type and structure (e.g. same columns).
4. You can also easily apply more transformation or extraction steps by modifying the automatically generated sample query without having to worry about modifying or creating additional functional query steps.If the above solution can help you, that would be great.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi, sns1996
When you need to merge daily loaded data files into one table and delete these files at the end of the month. You can use the "Combine Files" feature in Power Query Editor to combine multiple files with the same pattern into a logical table. Here are the steps on how to do it:
1. Open Power BI Desktop.
2. Select Get Data.3. Select File > Folder.
4. Enter the path to the folder containing the files you want to merge and select Connect.5.In Power Query Editor, you will see all the files in the folder.
6. Select Content (first column of labels), then select Home > Combine files. You can also directly select the Merge Files icon.Merging files behaves as follows:
It analyzes each input file to determine the correct file format to use, such as text, Excel workbook, or JSON file. You can select specific objects (such as an Excel workbook) from the first file to extract.
It automatically does the following:
1. Create a sample query to perform all required extraction steps in a single file.
2. Create a function query that parameterizes the file/binary input into the example query. Sample queries and function queries are related to each other, so changes to the sample query are reflected in the function query.
Applies a function query to the input binary of the original query, such as a folder query. It applies a function query on binary input to each row and then expands the resulting data extract into top-level columns.
3. Using the merge files behavior you can easily merge all the files in a given folder into one table if the files have the same file type and structure (e.g. same columns).
4. You can also easily apply more transformation or extraction steps by modifying the automatically generated sample query without having to worry about modifying or creating additional functional query steps.If the above solution can help you, that would be great.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
