Analyze In Excel Model Didn't Refresh

[mkornel]

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!

[v-robertq-msft]

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