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 to import all the data up to the previous day, and then get today's data with a table in direct query mode and create relationships to a dimensions table that contains all the IDs, Instruments and times. This model is very close to working however my issue is getting the IDs, Instruments and times where I don't have to get them all in direct query mode.
Is there any way to bring in most of the dimension data in import and add a very small amount of real-time in direct query mode?
measures will not work as I need to be able to display the date information on an axis and the instrument on the legend.
3 Replies
- TomMartens
Super User
Hey 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
- amitchandak
In 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
- v-diye-msft
Community Support
Hi Anonymous
If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly.thanks!
