Trying to use the new Excel refresh feature announced in the May 2021 update. Connected an Excel file to a Power BI dataset (tried both via Analyze in Excel and using the Excel Get Data menu). Built a few pivot tables and charts, then published to the service (again, tried both using OneDrive and the direct Publish option from Excel). When I go to use the Excel file in the service, I get the following error:
External Data Refresh Failed
We were unable to refresh one or more data connections in this workbook. The following connections failed to refresh:
I am using the same credentials in Excel desktop and the service, and the file refreshes fine in Excel desktop.