Forum Discussion

gheesalias's avatar
gheesalias
Frequent Visitor
9 years ago
Solved

Connect Live SSAS

Hi,   1. Is the enterprise Gateway same as On Premises Data Gateway? 2. I live in a WORKGROUP(no AD) network, and I have reports which uses Live Power BI account as well as Imported one. And I hav...
Need Help
  • v-micsh-msft's avatar
    v-micsh-msft
    9 years ago

    Hi gheesalias,

    Yes you are right. Data is stored at the Server side when using live connection, not in Power BI service.

    For the import option, we need to schedule refresh in order to keep the data up-to-date.

    Check the article below for more information regarding Data refresh:

    Data refresh in Power BI

    If you have any further questions, please post back.

    Regards

     

v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
9 years ago

Hi gheesalias,

 

Yes, the enterprise gateway is the same as On Premises Data Gateway, which is the older name of On Premises Data Gateway.

If you would like to refresh dataset on your own computer, which is not in a domain environment, it is possible with Personal Gateway configured.

Power BI Gatway - Personal

For On-premises SSAS live connection, yes, it would always need an On Premises Data Gateway, check the article below for more details:

SQL Server Analysis Services live data in Power BI

"

Important:

  • In order to connect to a live Analysis Services server, an On-premises Data Gateway must be installed and configured by an administrator. For more information, see On-premises Data Gateway.

  • When you use the gateway, your data remains on-premises.  The reports you create based on that data are saved in the Power BI service. 

  • Q&A natural language querying is in preview for Analysis Services live connections.

"

If you have further questions, please feel free to post back.

Regards

  • gheesalias's avatar
    gheesalias
    Frequent Visitor
    9 years ago

    Thanks v-micsh-msft for your points, just 1 more quick question.

    Your point "When you use the gateway, your data remains on-premises.  The reports you create based on that data are saved in the Power BI service. ", what does this mean? If I have a live connection to SSAS Connection using Gateway, it is not stored in Power BI service, right? The data is stored in power BI service only if I use Import Query and in this particular situation, I can use Gateway to refresh the datasets at intervals, could you please correct me if I am wrong here?

    • v-micsh-msft's avatar
      v-micsh-msft
      Microsoft Employee
      9 years ago

      Hi gheesalias,

      Yes you are right. Data is stored at the Server side when using live connection, not in Power BI service.

      For the import option, we need to schedule refresh in order to keep the data up-to-date.

      Check the article below for more information regarding Data refresh:

      Data refresh in Power BI

      If you have any further questions, please post back.

      Regards