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?