Forum Discussion

mariah-pg's avatar
mariah-pg
Regular Visitor
4 years ago

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' dashbo...
General Comment
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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

  • mariah-pg's avatar
    mariah-pg
    Regular Visitor
    4 years ago

    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.