Add row for Direct query

[admin_xlsior]

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,

[Padam]

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

[amitchandak]

@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

[admin_xlsior]

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,

[AlexisOlson · Accepted solution]

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.

[admin_xlsior]

Yes, I actually understand this, only try to "push my luck". 😀

Then it is ok. 

Thanks,