There's a frustrating bug with Composit Models. Append Queries are somehow always flagged as direct queries, so you can't do transforms on any append query. You also can't load any append queries whe...
Hi BryantAvey,
The same issue has been reported before, you can view brianhartman's reply here: https://community.powerbi.com/t5/Issues/Composite-Models-Can-t-append-Tables-with-different-storage/idi-p/500347
Best Regards,
Qiuyun Yu