Skip to main content

Power BI

Needs Votes

Consolidating loaded data for a table in Power Query

Vote (0) Share
's profile image

on 24 May 2018 16:44:39

Hi,
I'd like to have the chance inside Power Query to consolidate the imported data into a table in order to avoid next data refresh. So I could working with consolidated tables (fixed at a certain date/time) not more updated. The feature could be useful when it is read a data source that contains only the last data respect a specific time interval (only the data of the last week, last month, last quarter): a next update of the data source could override the previous data that could not entered in PBI. This data consolidation feature could be implemented by a flag to avoid or allow the data refresh from the connected data source.
The feature should already function in Power BI desktop.
Thanks