Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Automatically update visuals throught direct query

hi, my company would like a simil real time dashboard using direct query with a power bi premium account.   we have power bi premium and we would like to know if it's possible to let the visuals i...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    It is unavailable to let the visuals in a report being updated without any interaction with the user.For DirectQuery, no data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, then you will view the updated data. As a workaround, you may try 'Automatic page refresh' which is suggested by GilbertQ . You can set automatic page refresh intervals for reports that have been authored in Power BI Desktop, and published to the Power BI service.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

It is unavailable to let the visuals in a report being updated without any interaction with the user.For DirectQuery, no data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, then you will view the updated data. As a workaround, you may try 'Automatic page refresh' which is suggested by GilbertQ . You can set automatic page refresh intervals for reports that have been authored in Power BI Desktop, and published to the Power BI service.

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.