Forum Discussion
How do I lock down my pivot table so it doesn't refresh?
I am trying to preserve historical reports so that I can look back at last month's reports without them refreshing. I don't know how to lock down the tables so they can't be refreshed. Is there...
Anonymous
I'm not sure I understand. I download and overwrite reports (excel tables) from a web interface nightly. So, I'm guessing I
import.
Yes, I am a newbie.
Thanks.
Phar,
The "Include in report refresh" comes from Power BI Desktop. However, you are using Power Query in Excel and create PowerPivot table, please post the question in Power Query forum or PowerPivot forum.
Power Query: https://social.technet.microsoft.com/Forums/en-US/home?forum=powerquery
PowerPivot: https://social.technet.microsoft.com/Forums/en-US/home?forum=sqlkjpowerpivotforexcel
Instead, you can use Power BI Desktop to create reports.
Regards,
Lydia