Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I was quite excited about the new Composite Models in Power BI. My desired use case is:
Import Bulk Data for past several months
Direct Query activity from 'Today'
Federate the results in a single table to give complete picture
The source database for this isn't perfect, so trying to Direct Query bulk data is a non-starter for performance.
I cannot find a way to achieve this result. Using a GDAX expression like 'Union' requires a data refresh as opposed to Direct Query Live updates, and I've not been able to get this working when attempting to use 'Dual' Storage or anything along those lines.
Is this supported? Any other ideas?
Thanks,
Mark
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |