Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
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.
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.
@prakash11440278 , Based on my intial testing, Seem like analyze in excel work like live connection. I doubt you can use in offline mode.
Hi @amitchandak ,
Thanks for the reply.
Can you please help me on, how we can change the pivot table into offline mode.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |