Excel linking to query in excel!

Hi Babycakes_00 ,
Thanks for posting in Microsoft Fabric Community.
To refresh data automatically you can use Power Automate.
Steps:
1. Create a Power Automate Flow:
Create a new flow:
    Choose Automated Cloud Flow.
    Use the trigger "When a file is created or modified in a folder" (SharePoint connector).

2. Configure the trigger
Set the Site Address:
Select or manually enter the URL of the SharePoint site where the  folder for Document 1 is located.
          Set the Folder:
          Choose the folder containing Document 1.

3. Get File Content From Document 1

Add the Get File Content action (SharePoint connector).
Configure the action:
         Site Address: Same as the trigger.
         File Identifier: Shared documents>Document 1

4. Update Document 2

1. Add the Update action (SharePoint connector).

2. Configure the action:

   Site Address: Select the SharePoint site where Document 2 is stored.
   Folder Path: Choose the folder containing Document 2.
   File Name: Document 2
   File Content: Use the dynamic content from the Get File Content action.
   

    

   
   
   
   

5. Test the flow
          Update Document 1 
          Confirm the flow runs automatically in Power Automate.
          The changes appear in Document 2 in SharePoint.

Hope this helps.

If this post helps , please accept as solution to help others find easily and a Kudos would be greatly appreciated.

Best Regards,
Vinay.