Power Query in Excel does not automatically load new data

%3CLINGO-SUB%20id%3D%22lingo-sub-2715707%22%20slang%3D%22en-US%22%3EPower%20Query%20in%20Excel%20does%20not%20automatically%20load%20new%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2715707%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20MS%20community%2C%20happy%20Friday!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20an%20issue%20with%20Excel's%20power%20query%20function.%20Here%20is%20the%20situation%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20have%20one%20excel%20sheet%20with%20a%20table%20that%20automatically%20gets%20a%20row%20added%20to%20it%20when%20a%20file%20is%20added%20in%20sharepoint.%20(Power%20Automate)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20I%20have%20another%20excel%20sheet%20which%20I%20have%20linked%20to%20Table1%20using%20power%20query%20to%20extract%20the%20product%20name%20from%20the%20file%20added%20in%20sharepoint.%20The%20query%20works%20perfectly%20to%20do%20what%20I%20want.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%20that%20the%20excel%20sheet%20with%20the%20power%20query%20does%20not%20load%20new%20data%20when%20the%20source%20table%20has%20been%20updated%20with%20power%20automate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20hover%20over%20my%20queries%20I%20can%20see%20that%20the%20preview%20has%20loaded%20in%20the%20new%20rows%20like%20I%20want%20but%20it%20does%20not%20load%20it%20into%20the%20sheet%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20looked%20at%20all%20the%20settings%2C%20and%20I%20have%20set%20the%20query%20to%20auto%20refresh%20every%20few%20minutes%2C%20however%20the%20%22Last%20refreshed%22%20time%20stays%20constant%20and%20does%20not%20change%20even%20when%20I%20manually%20refresh%20the%20query.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20also%20looked%20at%20the%20load%20to%20settings%2C%20but%20when%20I%20select%20load%20to%20table%20it%20gives%20me%20an%20error%20saying%20that%20it%20can't%20overlap%20an%20existing%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20how%20I%20can%20fix%20this%20so%20the%20query%20automatically%20refreshes%20and%20loads%20the%20new%20rows%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20some%20screenshots%20for%20more%20insight%2C%20any%20help%20would%20be%20very%20helpful!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20case%20scenario%20for%20me%20would%20be%20that%20when%20a%20new%20row%20is%20added%20to%20the%20source%20table%2C%20power%20query%20automatically%20transforms%20the%20data%20how%20I%20set%20it%20up%2C%20and%20the%20automatically%20loads%20a%20new%20row%20into%20the%20result%20table%20without%20me%20having%20to%20do%20anything.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Query1.PNG%22%20style%3D%22width%3A%20483px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F307887i2EEFAC21CBFAB97D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Query1.PNG%22%20alt%3D%22Query1.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Query2.PNG%22%20style%3D%22width%3A%20961px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F307888i456603AAEEB5C666%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Query2.PNG%22%20alt%3D%22Query2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Query3.png%22%20style%3D%22width%3A%20924px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F307890i66634F8B53F63662%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Query3.png%22%20alt%3D%22Query3.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Query4.PNG%22%20style%3D%22width%3A%20564px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F307889iBBDE899CFB89641A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Query4.PNG%22%20alt%3D%22Query4.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Query5.PNG%22%20style%3D%22width%3A%20382px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F307891i7B799AE1B54AFC41%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Query5.PNG%22%20alt%3D%22Query5.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Query6.PNG%22%20style%3D%22width%3A%20595px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F307892i468CD02AA3685D0B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Query6.PNG%22%20alt%3D%22Query6.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2715707%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2721211%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20in%20Excel%20does%20not%20automatically%20load%20new%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2721211%22%20slang%3D%22en-US%22%3Eis%20the%20table%20in%20sharepoint%20an%20excel%20formatted%20table%3F%20or%20is%20it%20just%20a%20regular%20data%20range%3F%3C%2FLINGO-BODY%3E
New Contributor

Hello MS community, happy Friday!

 

I am having an issue with Excel's power query function. Here is the situation:

 

So I have one excel sheet with a table that automatically gets a row added to it when a file is added in sharepoint. (Power Automate)

 

Then I have another excel sheet which I have linked to Table1 using power query to extract the product name from the file added in sharepoint. The query works perfectly to do what I want.

 

The problem is that the excel sheet with the power query does not load new data when the source table has been updated with power automate.

 

When I hover over my queries I can see that the preview has loaded in the new rows like I want but it does not load it into the sheet?

 

I have looked at all the settings, and I have set the query to auto refresh every few minutes, however the "Last refreshed" time stays constant and does not change even when I manually refresh the query.

 

I have also looked at the load to settings, but when I select load to table it gives me an error saying that it can't overlap an existing table.

 

Any ideas how I can fix this so the query automatically refreshes and loads the new rows as well.

 

Here are some screenshots for more insight, any help would be very helpful!

 

Best case scenario for me would be that when a new row is added to the source table, power query automatically transforms the data how I set it up, and the automatically loads a new row into the result table without me having to do anything.

 

Query1.PNGQuery2.PNGQuery3.pngQuery4.PNGQuery5.PNGQuery6.PNG

 

1 Reply
is the table in sharepoint an excel formatted table? or is it just a regular data range?