Forum Discussion

lukiz84's avatar
lukiz84
Memorable Member
1 year ago

Fabric CU consumption when using SSAS Live Connection via Gateway

Hi,

 

I just found out that I can use my OnPrem SSAS Tabular DB via an enterprise gateway in the PowerBI Workspace. We have a F128 Fabric capacity and I was curious if there are CUs consumed when being live connected in a pbix to OnPrem SSAS Tabular?

 

If so, how can I find out how much?

 

best regards

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Yes.  How much? That depends on the performance of your SSAS Tabular.  CUs are a combination of time and (Fabric) compute so in your case it would be mostly the time component.

    • lukiz84's avatar
      lukiz84
      Memorable Member
      1 year ago

      Hi,

       

      thanks for your reply. I know I was a bit unspecific. But in general, the question for me is, what fabric has to "calculate" because everything should be done on the SSAS side in my opinion.

       

      I'm just considering what would be best in consumption, the model is like 10gb and has 150-200 users.

       

      thanks anyways!

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi lukiz84 

         

        Maybe you can consider using the Microsoft Fabric Capacity Metrics.

        The Microsoft Fabric Capacity Metrics app is designed to provide monitoring capabilities for Microsoft Fabric capacities. Use the app to monitor your capacity consumption and make informed decisions on how to use your capacity resources. For example, the app can help identify when to scale up your capacity or when to turn on autoscale.

        What is the Microsoft Fabric Capacity Metrics app? - Microsoft Fabric | Microsoft Learn

         

        Best Regards

        Zhengdong Xu
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.