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 the Power App writes to, that I'd like to update after each submission. My goal is to have one table that contains mostly information from the imported table, and a few fields from the Power App DQ table. I've tried to methods and I'm getting the same non-working result.
1. I merged the queries in Power Query as a left outer join from the imported to the Direct Query table. The new data source this resulted in is in Import mode, so it won't work.
2. I linked the queries in the design editor. It defaults to a 1:1 relationship with security both directions, but this won't work because the DQ table only has a fraction of the rows as the imported source. So I changed it to a *:1 relationship, where the imported table filters the DQ table. This works for everything, except it now won't pass the fields in the imported table to the Power App. I have another table that consists of only imported fields. If I click on a row in the main table that has a DQ record, the other table filters fine. If I click on a row that doesn't exist in DQ, the other table is blank and won't display anything. It's almost as if it's still being treated as a Both security filter.
Any thoughts on how I can accomplish this?
