I receive Covid-19 patients report everyday that I save in a folder. These reports have similar data-set and I have to create a consolidated report using these multiple files. How I do: I have to manually save each report in a folder than copy paste its data to a Master sheet which takes considerable amount of time. How can I do it better : You can create a Master Sheet with Power Query in Microsoft Excel and Power BI that consolidates your excel/ csv file reports at one plae and also provides option like Refresh . Power Query comes with the feature of Refresh that you can use to either refresh your Master Sheet data to update changes in your existing reports or to update data of new file from your Master folder. To know how to do above action, click on the tab according to your software preferences Microsoft Excel Power BI Microsoft Excel ABOUT: With Power Query, you can search for data sources, make links, and then form the data in ways the suit y...
Automate your daily work in 3 easy steps.