How do you leverage Power BI's Composite Model to combine import and DirectQuery data sources within the same report?
I’m working on a Power BI report that needs to combine data from multiple sources. Some data is more efficiently handled using DirectQuery for real-time updates, while other data is better suited for the Import method to improve performance. How can I effectively use Power BI's Composite Model to combine these sources within a single report while ensuring optimal performance and accuracy?