Forum Discussion

felipea's avatar
felipea
New Member
7 years ago

Excel Pivot Table with SSAS fails to refresh

Hi Everyone!   I have create a excel report with an Analysis Services database source. This workbook is published in my Power BI subscription but the data refresh fails. The same source is used fo...
analysis services
Refresh Schedule Error
SSAS
ITGeek555's avatar
ITGeek555
Icon for Helper II rankHelper II
7 years ago

Could you provide the refresh failure error message?

Is the data source name in the Excel report the same as that which is listed in the Gateway.  It has to be exactly the same.  Perhaps compare the data source details of the report that is working with the one that is failing.

This GuyInACube video provides good info on fault finding gateway connection issues.