Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Have single direct query for multiple visuals

I have a query for a table in database.From it I am creating 4 visuals.But each individual visual is sending a seperate query to database in direct query mode and it is making my report slower. Is t...
  • v-alq-msft's avatar
    6 years ago

    Hi, Anonymous 

     

    It is unavailable to have a single query for a table and multiple visuals load from the result in your scenario. During the initial Get Data experience, the source is selected. For relational sources, a set of tables are selected and each still define a query that logically returns a set of data. However, upon load, no data is imported into the Power BI store. Instead, upon building a visual within Power BI Desktop, queries are sent to the underlying data source to retrieve the necessary data. The time taken to refresh the visual depends on the performance of the underlying data source. I'd like to suggest you reduce the number of visuals and interactions with visuals to improve your report.

     

    For further information, you may refer the official document .

     

    Best Regards

    Allan

     

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