Analyze in excel offline mode

[prakash11440278]

Hi Power BI Experts,

However, when we use Analyze in Excel. Excel’s data is fetched live from the Power BI dataset in the service. I want the power pivot table should be available in offline mode why because user doesn't want to wait long time when they slice and dice the filters. How to available the power pivot excel into offline mode.

[v-lionel-msft · Accepted solution]

Hi @prakash11440278 ,

The "Analyze in Excel" feature does not support offline mode in current version.
Maybe you can try to use the "Export data" feature.

Export summarized data 

Or submit your idea 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@prakash11440278 , Based on my intial testing, Seem like analyze in excel work like live connection. I doubt you can use in offline mode.

[prakash11440278]

Hi @amitchandak ,

Thanks for the reply.

Can you please help me on, how we can change the pivot table into offline mode.

[Pragati11]

Hi @prakash11440278 ,

"Analyze in Excel" is a feature for Power BI Service. Refer link below:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

Thanks,

Pragati