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...
Need Help
  • 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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

abernal，

It is possible to use on-premises gateway to refresh your dataset in Power BI Service, please take a look at this official article.

And I test same scenario as yours, refresh works well when I use on-premises gateway.


Regards,
Lydia

abernal's avatar
abernal
Frequent Visitor
8 years ago

Thank you Lydia.

I got it to work with an Excel workbook that contains a Power Pivot model that connects to an on-premises SQL Server database. I did not work, however, if the Power Pivot model connects to an Analysis Services Tabular database. I checked all the configurations and I am pretty sure that they are correct. Could you please perform the same test that you did before, but having instead a Power Pivot model that connects to an Analysis Services Tabular database? By the way, our Analysis Services Tabular database server is 2012. 

 

Below as some screenshots of my settings screens:

 

1) on-prem data gateway appears online for power pviot models that have a SQL Server connection... 

 2) on-prem data gateway appears offline for power pviot models that have a Analysis Services tabular connection... 

 

 

 

Thank you in advance for your assistance,

 

Alex 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    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

    • abernal's avatar
      abernal
      Frequent Visitor
      8 years ago

      Thank you Lydia.