Connect Live to AAS / AAS DirectQuery OFF

[Anonymous]

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.

[GilbertQ]

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.