Forum Discussion
Combine data from both import and directquery tables
I have a database that is bringing in IoT data. I want to speed up visuals in Power BI, currently, they take >20seconds to draw due to the direct queries that have to be performed. My plan was t...
TomMartens
Super User
Super UserHey Anonymous ,
there is a concept for your problem, called Aggregations, read about it here:
https://docs.microsoft.com/en-us/power-bi/desktop-aggregations
I recommend this article to get you started:
https://shabnamwatson.wordpress.com/2019/11/21/aggregations-in-power-bi/
There are a lot of articles, and videos around aggregations.
Hopefully, this provides you with some new ideas to tackle your challenge.
Regards,
Tom
amitchandakSuper User
Super UserIn addition to what has been provided my TomMartens , You can refer:https://community.powerbi.com/t5/MBAS-Gallery/Aggregation-and-composite-model-Microsoft-Power-BI-fast-and/td-p/712871