Composite Models: Can't append Tables with different storage modes
Submitted byAnonymouson08-27-201808:35 AM
Using the new 'composite models' feature introduced in July 18, I have created two identical tables.
One is Direct Query (Last Days Data), the other is imported (Last Weeks Data). I wanted to append these tables into a new table which would result in a union of the data. After saving from the Query Editor, I recieve an error message:
'This query contains tranformations that can't be used for DirectQuery'