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...
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.
