Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |