Forum Discussion
AGo
Post Patron
Post PatronHistorical 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...
v-lionel-msft
Community Support
Community SupportHi AGo ,
"is it possible in PowerBI (using Power Query) to append historical data not refreshing to a refreshing same-structured table?"
According to your description, you seem to want to append historical data in a non-refresh way in "Edit Queries".
You can select "Home" -> "Append Queries" options to achieve it, but if you use "Direct Query" or "Live connection" mode, you can't use the feature.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.