Forum Discussion
Solved
Add row for Direct query
Hi, Just looking for some ideas, I'm using Direct Query however there is one table that I feel I need to add additional row, at least 1 row. Take example I have a table for grouping something li...
Purely DirectQuery while adding local data sounds contradictory to me. Either add the row in the source or use a mixed mode. To not be mixed mode, you'd need the additional row to be DirectQuery too.
You can add a Union statement in the Power Query Editor with your existing query.
Eg:
Select distinct Column1 from Table1
UNION
Select "DynamicData" as Column1