Merge an import table with direct query table

[Anonymous]

Hi community,

I want to know if it is possible to merge a direct query table with an imported table, if not possible do you have other alternatives ? What I want is to retrieve on column from my imported table to my direct query table 

Thanks in advance

[Anonymous]

THANKS @Anonymous  🙂

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Sheet1 is the Import table:

The table sysdiagrams is a Direct Query table:

Experiment: Insert the [group] of the Import table into sysdiagrams

1. You cannot use Merge Queries to merge the Import table with the Direct Query table

The following error will appear:

For specific explanations, you can check the following related links:

https://community.powerbi.com/t5/Desktop/Direct-Query-Mode-merging-queries-as-new-query/m-p/612961

https://community.powerbi.com/t5/Desktop/Append-operation-in-quot-Edit-Query-quot-with-the-mode-Direct/td-p/86394

2. You can use the Lookvalue function to achieve

Create measure.

Import_Group = LOOKUPVALUE('Sheet1'[group],Sheet1[version],MAX('sysdiagrams'[version]))

Result：

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly