Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Connect Live to AAS / AAS DirectQuery OFF

Hello,

 

It is my impression that these are two of the valid data connection options for Power BI / Azure Analysis Services:

 

[1] - Power BI <-> Connect Live <-> AAS <-> DirectQuery <-> Azure SQL Source

[2] - Power BI <-> Connect Live <-> AAS In-Memory Tabular DB <-> Scheduled Refresh Process <-> Azure SQL Source

 

I have tested scenario [1], and the Power BI Service dashboard refreshes instantly when I refresh the browser after Azure SQL Source changes as I expect.

When I test scenario [2], I run the scheduled refresh process, and I confirm the AAS data was refreshed with DAX EVALUATE() query. However, the Power BI Service dashboard does not refresh ... unless I go to the published dataset and click "Refresh Now", or select "More ..." -> "Refresh" on the tile. Is this expected behavior for Connect Live?

 

Thanks in advance for an information anyone can provide.

 

Cheers.

1 Reply

  • Hi Anonymous 

    The dashboard cache on your scenario 2 has its own scheduled refresh would happens on that schedule. Which means it is not instant.

    You can go into your dataset settings and see the settings as shown below.