Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Upload Excel with Power Pivot Model unable to refresh

Unable to refresh an Excel file when uploaded to Power BI Service. The uploaded Excel 2016 file contains a Power Pivot Model connected to a SQL Server 2014 tabular model. The following error message is displayed after refreshing.

 

PBIServiceRefresh.PNG

 

 

Status: Needs Info
Comments
AnniePower
Frequent Visitor

We are using Excel 2013.  I've tried refreshing files connected to SQL Server 2012, 2008 R2, 2016, as well as SSAS 2012 both MD & tabular.  Tried using the enterprise gateway, as well as the personal gateway.  No Excel connections will refresh when the xlsx is uploaded.  If you import the dataset, it refreshes fine.  If you convert the same files to pbix, it refreshes fine.

 

In November, during an initial test, we were able to refresh excel files connected to SQL Server (but not SSAS).  Those same files have stopped refreshing. 

v-qiuyu-msft
Community Support

@Anonymous It seems you upload the Excel Workbook instead of Import to Power BI service, right? As your workbook get data from SSAS which requires gateway, did you configure personal gateway or on-premise data gateway for this workbook?

 

@AnniePower Regarding this issue, please create a support ticket to get dedicated support.

 

Best Regards,
Qiuyun Yu

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
Anonymous
Not applicable

@v-qiuyu-msft That is correct. This Excel Workbook was Upload to Power BI instead of Import to Power BI. The Excel Workbook gets data from SSAS over an on-premise data gateway. The on-premise data gateway is able to connect to SSAS model directly or SQL DB directly. This has been attempted using a personal gateway, but recieived the same error message. 

Annietwo
Frequent Visitor

Is there any update on this?  Refresh still broken for excel files?