Forum Discussion
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 like :
| Group id | Name |
| Group01 | High |
| Group02 | Low |
For some reason, I need to add another row for Group03:Medium, but it is only reside in my Power BI, not in my data source.
Is it possible?
Thanks,
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.
5 Replies
admin_xlsior , if you ready to make this table as import mode table you can create a table using enter data with this new entry and append and create a table, that table will be an import mode table. Others can be still direct query
Hi amitchandak ,
Problem is I can't have hybrid/mixed mode. Need to be pure Direct Query mode. That's why whether probably there is some trick to add the row. I'm not sure how, probably from power query first or something else.
Thanks,
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
