cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rfrikha1992
Helper I
Helper I

Increment files on Power Query

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 🙂 ^^ 

 

2 ACCEPTED SOLUTIONS
v-henryk-mstf
Community Support
Community Support

Hi @Rfrikha1992 ,

 

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:

vhenrykmstf_0-1624244193757.pngvhenrykmstf_4-1624244305242.png

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.

vhenrykmstf_2-1624244255613.png

vhenrykmstf_3-1624244275872.png

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.

View solution in original post

Weav8060
Frequent Visitor

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.

View solution in original post

2 REPLIES 2
Weav8060
Frequent Visitor

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.

View solution in original post

v-henryk-mstf
Community Support
Community Support

Hi @Rfrikha1992 ,

 

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:

vhenrykmstf_0-1624244193757.pngvhenrykmstf_4-1624244305242.png

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.

vhenrykmstf_2-1624244255613.png

vhenrykmstf_3-1624244275872.png

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.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.