Forum Discussion
Solved
Direct Query : trick to add rows ?
Dear friends, In Direct Query (as I know of), we cannot add our own rows as all is from the "live" data source, and we cannot add table as well, unless the table is derived or manipulated from ex...
If you must use pure DirectQuery, then you need to have a DirectQuery source that has all the things you need. It can still be a separate table but without composite modeling, it has to come from the source.
admin_xlsior Sounds like you need to create a composite model and perhaps use an Enter Data query to add the all of the statuses to that.
Yeah, but too bad, as I'm gonna use this report in my ERP, and it is demand to use pure Direct Query, cannot choose composite.
Can something in the Power Query do something about this ?
Thanks
If you must use pure DirectQuery, then you need to have a DirectQuery source that has all the things you need. It can still be a separate table but without composite modeling, it has to come from the source.
