Forum Discussion
Post ProdigyAnalyze in Excel into offline data
Analyze in Excel is Live Connection, you cannot make it "Offline". Instead you could use Export Data then analyze the exported table in Excel Power Query.
Introduction to Microsoft Power Query for Excel - Excel
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Post ProdigyHi Anonymous ,
Thanks for the reply.
User doesn't want to wait more time if they swith from one filter to other. I want my whole power bi model should be available in offline mode as pivot table even if user selected multiple slicers it dont want hit backend power bi dataset. I dont want to use the export option in the visual because in pivot table we have many slicers and user want to slice & dice based on the selection. Please help.