Forum Discussion
Mark Le Lay
Mar 15, 2018Copper Contributor
Daily changing file to export data into excel
I would like to import data every day from a device connected to my home network, i have access through port forwarding to the device which provides the data stored in the following format:
htt...
SergeiBaklan
Mar 16, 2018Diamond Contributor
Hi Mark,
As an idea with using Power Query- you may generate calendar table with only one column with dates for which you'd like to pick up your data (could be done by power query with any start date and today as end date). To this table add one more column with function which returns table with data from your file for each row.
Parameter for the function is the date in the row, it generates URL based on it and return data. Basic formula will be Excel.Workbook(Web.Content("URL"), null, true).
After that expand this column, make additional data transformation if needed and return result to the Excel table, generate the chart based on it.
Refresh the query on file opening or manually.