Home

Power Query Data Table Scheduled Refresh

%3CLINGO-SUB%20id%3D%22lingo-sub-898254%22%20slang%3D%22en-US%22%3EPower%20Query%20Data%20Table%20Scheduled%20Refresh%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-898254%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20a%20custom%20Power%20Query%20that%20is%20retrieving%20database%20information%20from%20several%20tables.%20This%20data%20is%20mostly%20text%20based%20and%20I'd%20like%20a%20nicer%20way%20to%20present%20it.%20I%20believe%20this%20is%20possible%20using%20Microsoft%20Flow%20with%20Word%20Templates.%20My%20vision%20for%20this%20Flow%20is%20to%20have%20it%20run%20once%20per%20week%20based%20on%20a%20refreshed%20version%20of%20the%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20able%20to%20create%20a%20flow%20to%20access%20the%20rows%20of%20this%20data%20but%20in%20order%20for%20it%20to%20be%20fully%20automated%20I%20would%20need%20the%20Power%20Query%20data%20to%20be%20updated%20once%20a%20week.%20Is%20there%20a%20way%20to%20allow%20the%20spreadsheet%20to%20refresh%20itself%20weekly%20ahead%20of%20the%20execution%20of%20the%20Flow%3F%20In%20order%20for%20this%20to%20be%20truly%20seamless%2C%20I'd%20like%20to%20remove%20all%20manual%20aspects%20of%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20seen%20some%20info%20about%20using%20Sharepoint%20for%20this%20purpose%20but%20I%20do%20not%20see%20any%20options%20for%20a%20scheduled%20refresh%20of%20the%20back-end%20data.%20Is%20there%20any%20solutions%20out%20there%20for%20this%20purpose%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-898254%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPower%20Query%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Anonymous5
New Contributor

Hello,

 

I have created a custom Power Query that is retrieving database information from several tables. This data is mostly text based and I'd like a nicer way to present it. I believe this is possible using Microsoft Flow with Word Templates. My vision for this Flow is to have it run once per week based on a refreshed version of the spreadsheet.

 

I am able to create a flow to access the rows of this data but in order for it to be fully automated I would need the Power Query data to be updated once a week. Is there a way to allow the spreadsheet to refresh itself weekly ahead of the execution of the Flow? In order for this to be truly seamless, I'd like to remove all manual aspects of it. 

 

I have seen some info about using Sharepoint for this purpose but I do not see any options for a scheduled refresh of the back-end data. Is there any solutions out there for this purpose?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies