Forum Discussion

AGo's avatar
AGo
Icon for Post Patron rankPost Patron
6 years ago

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...
Need Help
Tips and Tricks
Tutorial Requests
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

AGo you can have historical data in dataflow and then combine it with new data. With dataflow you can freeze historical data and only run dataflow when you need to refresh historical data.

PBILover's avatar
PBILover
Icon for Helper V rankHelper V
2 years ago

AGo : How did you achieved this?