Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
5 years ago
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...
Tips and Tricks
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    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.

amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
admin_xlsior
Post Prodigy
5 years ago

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's avatar
    AlexisOlson
    Super User
    5 years ago

    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's avatar
      admin_xlsior
      Post Prodigy
      5 years ago

      Yes, I actually understand this, only try to "push my luck". ğŸ˜€

      Then it is ok. 

      Thanks,