Analyze in excel - Data Refresh Failed

[Raghu_1753]

While I'm performing Analyze in Excel task on my Dataset,  when I tried to add some fields into pivot table, I am facing an error called "Data Refresh Failed". Please let me know the issue. Thanks in advance.

[collinq · Accepted solution]

Hi @Raghu_1753 ,

In a connection in Excel any measures that are in place have to be defined before coming into Excel.  This article might be helpful Troubleshoot connecting Excel to Power BI data - Power BI | Microsoft Learn    This article also exlains a number of other Limitations:  Start in Power BI with Analyze in Excel - Power BI | Microsoft Learn