Increment files on Power Query

[Anonymous]

Greeting all , 

Let's Assume that i have an Excel file Called A that loaded into sharepoint with the Data from 1 March to 7 March . 

Next week that file is deleted and another file Called B contains Data from  8 march to 14 march . 

My problem here is there a way i can save data From the A File and add the rows from the B File to them etc ....

in another word can i apply the historisation in Power BI ? 

Thanks all in advance 🙂 ^^ 

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

My understanding is that you want to add the data in file B to file A and merge it. First make sure that the merged data has the same data structure. Then I did a test, the reference is as follows:

You can import the B file into powerbi first, and then use the "append queries" function to merge the data of the B file and the A file.

If you are importing files from the same folder, you can also merge them in the following ways: Power Query Combine Files from Folder - Xelplus - Leila Gharani

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Weav8060 · Accepted solution]

I do incremental updates in Excel to create a master file, and that file feeds PBI.   PQ in Excel compares the SharePoint data to the Master Table (MT) loaded from the Excel front end in the previous iteration of the refresh, and by comparing the two determines the incremental component and the fixed component.  The query that feeds that TMT is the query that appends these two data sets.  The reason it works is that the Excel front end IS IN FACT a static copy of the previously PQ iteration from the network data.   First, have PQ generate the MT from the SharePoint data; then create a new query in PQ that grabs and MT; finally amend the logic in the two queries so they generate the two pieces to be combined back into the one behind the MT.

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

My understanding is that you want to add the data in file B to file A and merge it. First make sure that the merged data has the same data structure. Then I did a test, the reference is as follows:

You can import the B file into powerbi first, and then use the "append queries" function to merge the data of the B file and the A file.

If you are importing files from the same folder, you can also merge them in the following ways: Power Query Combine Files from Folder - Xelplus - Leila Gharani

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.