Forum Discussion

abernal's avatar
abernal
Frequent Visitor
8 years ago
Solved

Data gateway mode required to refresh an Excel workbook in Power BI with a Power Pivot data model

I have an Excel workbook uploaded to the Power BI service under the workbooks tab that has a Power Pivot data model which connects to an on-premises SQL server database. I have been able to successfu...
  • Anonymous's avatar
    Anonymous
    8 years ago

    abernal,

    I can't use on-premises gateway when connecting to SSAS in Excel. Only peronal mode gateway can be used in this case.

    Regards,
    Lydia