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.

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,