Forum Discussion
Historical data
Hello, is it possible in PowerBI (using Power Query) to append historical data not refreshing to a refreshing same-structured table? After that I wouldn't be able to connect to the DB anymore, t...
AGo if you add new columns as DAX expression you don't need to refresh the dataset, it is always added on existing dataset. You need to know basic fundamentals , difference betwee adding column using power query or getting new columns from datasource vs calculating column using DAX. Wiht DAX, it works on existing loaded data.
Yes I know, but unfortunately some functions for derived data are not available in dax (like intelligent unpivoting and row number indexing without ranking). That's why I need to literally freeze historical data besides that it's impossible for me to query historical data in 2 hours limit or mandatory refreshing datasource everytime I apply changes on derived data functions. I hope there's a solution.
