Forum Discussion

MSBIDev2012's avatar
MSBIDev2012
Frequent Visitor
8 years ago

PowerBI with Tabular SSAS - Analysis services connector or Gateway?

Hi, We have a scenario where our PowerBI dashboards connect to Tabular Analysis services using live connection. Here are a few points about the environment:   a) The Analysis Services Tabular cube...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi MSBIDev2012,

 

Which type of AS datasource you mentioned? Can you please share more detailed contents?

 

>>b) We have a huge workload going up to many thousands of users.

If these users are in same tenant, you can use one gateway to handling multiple refresh request.

Manage your data source - SQL Server

 

For performance issues, I'd like to suggest you take a look at below article:

Power BI Performance Best Practices

 

Regards,

Xiaoxin Sheng

MSBIDev2012's avatar
MSBIDev2012
Frequent Visitor
8 years ago

Thanks Xiaoxin! AS is SQL Server 2016 Tabular Analysis Services model on an Azure VM.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI MSBIDev2012,

     

    >>AS is SQL Server 2016 Tabular Analysis Services model on an Azure VM.

    It seems like you are using a on-premise datasource. 

     

    In my opinion, 'connection directly' mode will be more suitable with huge workload situation.(online datasource)


    Since you are using on-premise datasource, connection directly mode not work for your scenario, so you had to set up a gateway to manage refresh operation.

     

     

    Regards,

    Xiaoxin Sheng