Hi all,
I created Analzye In Excel file. When I click "Refresh All" system displays the following message (see the screenshot attached). It worked previously and I didn't change anything in the file. Any ideas why this may happen? I installed the latest Analyze In Excel updates.
What I noticed that one of my pivot tables don't display the latest data and I don't see it in the filter drop-down. But, when I sort the column from A-Z (or Z-A), it appears. Maybe that is the reason, but I don't know how to address it. I set "Data source order" as a sorting option.
Thanks in advance!
Comments
- nharding1 on: Power BI Azure maps legend colours issue
- getsmithed on: Dynamic Subscription Sent Default Page instead of ...
- paulbodman on: PowerBI Online - Line/ Area Chart Issue after the ...
-
mattlee
on:
Unremovable Scroll Bars
- _Airat_ on: Card Visual -> Reference ->Details -> Background -...
- _Airat_ on: Slicer's drop-down list covers the Data pane
- Chetanpanwar on: Potential Microsoft Fabric Copy Job Issue – Increm...
-
Aaryan_23
on:
Gateway 3000.322.4 (June 2026): refreshes failing ...
- _Airat_ on: PowerBI There's not enough memory to complete this...
- ex_kjetilh on: æøå not supported after update 30th june?
Hi,
As far as I’m concerned, the Analyze In Excel file is live connected to the Power BI dataset you created in the Power BI service. So I think the Excel file will display the latest data every time you interact with the pivot tables in the Excel file like sorting from A-Z (or Z-A).
For more info, please refer to this link:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
Best Regards,
Community Support Team _Robert Qin