Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
mariah-pg
Regular Visitor

Does PowerBI Dashboard Break While AAS Model is Refreshing?

Hello, I have some large tables that take quite a bit of time to refresh (+7 hours). If I refresh the AAS model (via SSMS or Visual Studio) 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 if they are editing visuals while the refresh/deploy is happening?

 

I inadvertently tested this today and my test PBI dashboard did not refresh until I hit "Refresh". I'm wondering if someone  hits "Refresh" while AAS is updating, what will happen?

 

Thanks!

2 REPLIES 2
amitchandak
Super User
Super User

@mariah-pg , I am assuming AAS refresh is happing at AAS. At that time does AAS allow query the data, if yes then power will get data(hoping live connection) . Ideally incremental should be done at day end.

 

For dashboard, you can schedule as refresh.

 

for more , need info like , where refresh is happing, connection type in power bi

Hi @amitchandak , thank you for the response and info! 

 

Hm.. where are other places for AAS refresh to happen? I use ADF/SSMS/VS to refresh/deploy updates/new data. Are there other ways to refresh AAS?

 

Your statement is my question (thank you for articulating it!) - does AAS allow data queries while refresh is happening? If so, is that data the old data, the new data, or both?

 

Yes, I agree incremental is ideal, but the data doesnt have a partition. Are there other ways to do incremental loads?

 

More details:

Yes, Power BI is connecting to the data in AAS via Live Connection.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.