Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Merge an import table with direct query table

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

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @Anonymous ,

Sheet1 is the Import table:

vyangliumsft_0-1627009383991.png

The table sysdiagrams is a Direct Query table:

vyangliumsft_1-1627009383994.png

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

vyangliumsft_2-1627009384000.png

The following error will appear:

vyangliumsft_3-1627009384001.png

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:

vyangliumsft_4-1627009384002.png

 

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

THANKS @v-yangliu-msft  🙂

v-yangliu-msft
Community Support
Community Support

Hi  @Anonymous ,

Sheet1 is the Import table:

vyangliumsft_0-1627009383991.png

The table sysdiagrams is a Direct Query table:

vyangliumsft_1-1627009383994.png

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

vyangliumsft_2-1627009384000.png

The following error will appear:

vyangliumsft_3-1627009384001.png

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:

vyangliumsft_4-1627009384002.png

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.