Analyze in Excel into offline data

[prakash11440278]

Hi Power BI Experts,

When we use Analyze in Excel. Excel’s data is fetched live from the Power BI dataset in the service. I want to change the Analyze in excel pivot table into offline data. How can we do that?

[Anonymous]

@prakash11440278 

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.

[prakash11440278]

Hi @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.

[amitchandak]

@prakash11440278 , Based on my testing , Analyze in excel works like a live connection. I doubt you can analyze in offline mode.