Forum Discussion

AnniePower's avatar
AnniePower
Frequent Visitor
9 years ago

Excel File published to PBI won't refresh SSAS connections

We publish both PBIX and Excel/PowerPivot files to the service.  We have an enterprise gateway set up connected to SQL Server, AS-MD & AS-Tabular.  The PBIX files will refresh to all 3.  Excel file...
flemaistre's avatar
flemaistre
Advocate I
9 years ago

Hello

I have exactly the same issue

Excel 2016 file with powerpivot data model loading data from on-prem SSAS 2016, uploaded into PowerBI won't refresh with the enterprise data gateway. It works fine if the powerpivot data model loads data from SQL 2016, but not SSAS 2016.

 

It works fine as well with the Personal data gateway. I believe this could be brought up to Microsoft as a potential bug

 

Thanks