Determine which table to query data from

[wjkmason]

I have a dataset with imported tables that updates every 30 minutes (restricted by Power BI service).  I want to view live data on my production floor but don't want to sacrifice the performance aspect of soley using direct query.  Is there anyway in PowerBI to pull all historical data from the imported table and for the "new" data pull from direct query?

[amitchandak]

@wjkmason , I doubt append in power query and union in DAX can help much as they will create a new import table.

The way is to have two schemas around these two tables with common dimension and then add them in a formula

example measure

total rows = countrows(History) + countrows(Direct)