Forum Discussion

wmorris20's avatar
wmorris20
Helper II
9 years ago

Connect Live - SSAS - Update Frequency

We have an enterprise data gateway succesfully setup with live connections to SQL Server, SSAS MD, and SSAS Tab.  When viewing the refresh history, it shows that the refreshes are happening roughly e...
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi wmorris20,

 

As far as I know, if we connect to on-premise data sources use live connection or DirectQuery mode, when we interact with a visualization, queries are sent from Power BI directly to the database. Updated data is then returned and visualizations are updated. It's corresponding to the results which you have found. As schedule refresh is not supported in this scenario, we are not able to set refresh frequency. For more information, please refer to this article: Live connections and DirectQuery to on-premises data sources.

 

Best Regards,
Qiuyun Yu

wmorris20's avatar
wmorris20
Helper II
9 years ago

Qiuyun, when in DirectQuery mode (via SQL Server live connection), the data updates on interaction as you stated.  The issues is when I have a live connection interacting with SSAS.

 

Thanks,

Ward

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi wmorris20,

     

    I can reproduce the issue with SSAS tabular in live connection intermittently. And I already report this issue internally, will update here once I get any feedback.

     

    Best Regards,
    Qiuyun Yu

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Qiuyun,

       

      Just wondering if you have got any update regarding this problem? 

       

      Thanks!

      Lexi