Forum Discussion
Record and Store Values From One Table to Another
Hi I have been stuggling to find the right keywords to search online that would give me what I am looking for. Here is my scenario. I have a table (we'll call SourceTable) that is compri...
Hi PaulMac ,
Agree with @ BA_Pete, Power Query is a tool which can transform data as your need before you import data tables into Power BI Desktop, refer: Power Query Editor .
It is not supported and not a media to store history data in it, each time when you click the refresh button in Power Query editor, it would send queries to the data source and get the latest data.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.