Forum Discussion
Analyze in excel - Data Refresh Failed
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.
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
1 Reply
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