Forum Discussion
How to avoid data refreshing when applying query changes?
Hi, I have a Power BI report that purposely is not refreshed anymore due to the need to reflect the data as how it was stored at a certain point in time a while ago. Now there is a need to make a...
Hi Anonymous ,
Quick-and-dirty fix:
View your static table(s) in the Data view, right click on the table, select 'Copy table', paste to Excel/Access/Other in order to save as static position. Reconnect Power Query to this static source.
Pete
BA_Pete
Super User
Super UserHi Anonymous ,
Quick-and-dirty fix:
View your static table(s) in the Data view, right click on the table, select 'Copy table', paste to Excel/Access/Other in order to save as static position. Reconnect Power Query to this static source.
Pete
Went for this solution in the end, thanks for the suggestion!