locked
PowerBI with Tabular SSAS - Analysis services connector or Gateway? RRS feed

  • Question

  • 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 is residing in an IAAS environment. We are currently using Power BI Gateway.

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

    c) Our cube refreshes once every hour and Power BI creates a huge amount of pressure on infra as it has to refresh the cache for every user,query combination.

    Questions:

    1) I would like to know from the experts what would be the better option to choose between Analysis Services Connector and Power BI gateway. Would any of these perform better than the other in some scenarios?

    2) Is there a way we define what is an active connection for PowerBI? Looks like it caches queries for users who have logged in any time in the last 2 weeks.

    Any tips on cache management, setting recommendations are welcome.

    Thanks in advance!

    Wednesday, January 31, 2018 5:16 AM

Answers

  • Hi MSBI Dev 2012,

    Thanks for your question.

    According to your description, your problem is more related to Power BI. Since our forum is discussing Power Pivot issue, to solve your question more efficiently, please post your question in Power BI forum: http://community.powerbi.com,you will get a more professional support from there, thank you for your understanding and support.


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, January 31, 2018 6:04 AM

All replies

  • Hi MSBI Dev 2012,

    Thanks for your question.

    According to your description, your problem is more related to Power BI. Since our forum is discussing Power Pivot issue, to solve your question more efficiently, please post your question in Power BI forum: http://community.powerbi.com,you will get a more professional support from there, thank you for your understanding and support.


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, January 31, 2018 6:04 AM
  • Thanks. Will do as suggested.
    Wednesday, January 31, 2018 6:21 AM
  • Hi MSBI Dev 2012,

    Thanks for your understanding and supporting.


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, January 31, 2018 6:48 AM