Forum Discussion
Solved
Composite Data Source
I have a Power BI report with an integrated Power App. I have two data sources, one with a large amount of data that is being imported, and one table that is in direct query mode that is the table th...
The solution I finally found, was to link the imported table and the direct query table in the model, and in the main table made sure the fields I added from the direct query table were aggregated. This seemed to fix the issue.
Hi thuetten ,
Have you tried merging a direct query and an imported table using a left outer join in Power Query Editor? Like this:
Best Regards,
Winniz