Does PowerBI Dashboard Break While AAS Model is Refreshing?

Mariah 136 Reputation points
2021-10-12T17:57:34.777+00:00

I have some large tables that take quite a bit of time to refresh (+7 hours). If I refresh the AAS model containing these tables, will that affect end-users' dashboards throughout the duration of the refresh?

Will PowerBI know that a refresh is happening? Does it cache data until the refresh process is complete?

I'm trying to figure out if it's okay to do an AAS Deploy at any time in the day, or if it's best to wait until EOB when end-users are not actively working with the data? Will end-users get an error on their end while the refresh/deploy is happening?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,882 questions
0 comments
Accepted answer
  1. Dave Patrick 426K Reputation points MVP
    2021-10-12T18:14:33.583+00:00

    Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
    https://community.powerbi.com/

    --please don't forget to upvote and Accept as answer if the reply is helpful--

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mariah 136 Reputation points
    2021-10-22T23:49:46.997+00:00

    For anyone wondering in the future - no, an AAS refresh does not break PowerBI. AAS reads in all of the new data, once it's done reading data, it then deletes the old data. So yes, it basically caches the new data until the refresh is complete. If you run out of storage while the refresh is happening, then the refresh stops and it only keeps the old data.

    I'm extrapolating, but I'm guessing that if a user refreshes their PowerBI dashboard while an AAS refresh is happening, then the user would just get the old data (no refresh of data in Power BI).

    Here is a question that gives the answer a bit.

    0 comments