Forum Discussion
Integrated DirectQuery data with Imported data cannot be published to workspace
Hi! I have a 'master' report with master data and 2 other reports from which I DirectQuery data into the master report. I want to combine the master data, with the data from the other two report...
lbendlin
Super User
Super UserI think you can (ab)use the Aggregation feature for this. Treat the Master table as the aggregation table, and the Direct Query as the "Details" table. That would then result in the data being fetched first from the ... never mind.
How about incremental refresh with the hot partition pointing to the Direct Query?
Here are some optimization hints for these: https://blog.crossjoin.co.uk/2024/02/25/datacoveragedefinition-a-new-optimisation-for-hybrid-tables-in-power-bi/