How to Append queries in Power BI / Power Query with Union instead of Union AllPower Query - Select Columns from table instead of removing afterwardsPower Query - Count if custom functionNeed M Script to sum values from joined/merged queriesHow to subquery using M in Power Query/Power BIPower Query - Table.SelectRowsRemove duplicates from single column power queryPower BI - Finding and Filtering Duplicates Across ColumnsUsing merge in Power Query while keeping native queryPower BI - weighted average yield across 2 tables of a given dateHow do I properly use table.group in a PowerQuery query to dynamically summarize different rows and columns?
What was an "insurance cover"?
Make Interviewee Comfortable in Potentially Intimate Environment
Creating a 16x16(NxN) grid
Do household ovens ventilate heat to the outdoors?
Wired to Wireless Doorbell
Does Rayami, First of the Fallen exile it self?
Why are Fuji lenses more expensive than others?
Would a flying character fall prone after dashing if they had lost a leg?
Are actors contractually obligated to certain things like going nude/ Sensual Scenes/ Gory Scenes?
US entry with tourist visa but past alcohol arrest
Is there a connection between IT and Ghostbusters?
Would Taiwan and China's dispute be solved if Taiwan gave up being the Republic of China?
Escape the labyrinth!
What are the end bytes of *.docx file format
As a discovery writer, how do I complete an unfinished novel (which has highly diverged from the original plot ) after a time-gap?
Are there hydrocarbons on the Moon?
Is the sentence "何でも忘れた" correct?
How could artificial intelligence harm us?
How does one calculate the distribution of the Matt Colville way of rolling stats?
Asking an expert in your field that you have never met to review your manuscript
Norwegian refuses EU delay (4.7 hours) compensation because it turned out there was nothing wrong with the aircraft
Writing a letter of recommendation for a mediocre student
Safely hang a mirror that does not have hooks
Microservices and Stored Procedures
How to Append queries in Power BI / Power Query with Union instead of Union All
Power Query - Select Columns from table instead of removing afterwardsPower Query - Count if custom functionNeed M Script to sum values from joined/merged queriesHow to subquery using M in Power Query/Power BIPower Query - Table.SelectRowsRemove duplicates from single column power queryPower BI - Finding and Filtering Duplicates Across ColumnsUsing merge in Power Query while keeping native queryPower BI - weighted average yield across 2 tables of a given dateHow do I properly use table.group in a PowerQuery query to dynamically summarize different rows and columns?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
When I try to combine two datasets (coming from same table with exactly the same structure), I'm using
Table.Combine(table1, table2)
Unfortunately this results in the following native SQL:
SELECT *
FROM table1
UNION ALL
SELECT *
FROM table2
I'd prefer to use a normal UNION instead... is there a way to achieve this in M?
powerbi powerquery m asked Mar 28 at 14:22
bo-ozbo-oz
1,9091 gold badge13 silver badges32 bronze badges
add a comment
|
When I try to combine two datasets (coming from same table with exactly the same structure), I'm using
Table.Combine(table1, table2)
Unfortunately this results in the following native SQL:
SELECT *
FROM table1
UNION ALL
SELECT *
FROM table2
I'd prefer to use a normal UNION instead... is there a way to achieve this in M?
powerbi powerquery m asked Mar 28 at 14:22
bo-ozbo-oz
1,9091 gold badge13 silver badges32 bronze badges
Why are you worried about this? Do you use direct query?
– Aldert
Mar 28 at 14:46
I'm not sure if you can get M to useUNIONin its native query or not, but you can remove duplicate rows after aUNION ALLto get the same end result.
– Alexis Olson
Mar 28 at 14:52
Yes, that is what I;'m using now, but it seems a bit redundant. @Aldert, both fetch IDs from the same table, which could be duplicate IDs. When I use this product for my Join later on, it could cause unwanted duplication (Inner Join).
– bo-oz
Mar 28 at 16:19
add a comment
|
When I try to combine two datasets (coming from same table with exactly the same structure), I'm using
Table.Combine(table1, table2)
Unfortunately this results in the following native SQL:
SELECT *
FROM table1
UNION ALL
SELECT *
FROM table2
I'd prefer to use a normal UNION instead... is there a way to achieve this in M?
powerbi powerquery m asked Mar 28 at 14:22
bo-ozbo-oz
1,9091 gold badge13 silver badges32 bronze badges
When I try to combine two datasets (coming from same table with exactly the same structure), I'm using
Table.Combine(table1, table2)
Unfortunately this results in the following native SQL:
SELECT *
FROM table1
UNION ALL
SELECT *
FROM table2
I'd prefer to use a normal UNION instead... is there a way to achieve this in M?
powerbi powerquery m powerbi powerquery m asked Mar 28 at 14:22
bo-ozbo-oz
1,9091 gold badge13 silver badges32 bronze badges
asked Mar 28 at 14:22
bo-ozbo-oz
1,9091 gold badge13 silver badges32 bronze badges
asked Mar 28 at 14:22
bo-ozbo-oz
1,9091 gold badge13 silver badges32 bronze badges
asked Mar 28 at 14:22
bo-ozbo-oz
1,9091 gold badge13 silver badges32 bronze badges
asked Mar 28 at 14:22
bo-ozbo-oz
1,9091 gold badge13 silver badges32 bronze badges
1,9091 gold badge13 silver badges32 bronze badges
Why are you worried about this? Do you use direct query?
– Aldert
Mar 28 at 14:46
I'm not sure if you can get M to useUNIONin its native query or not, but you can remove duplicate rows after aUNION ALLto get the same end result.
– Alexis Olson
Mar 28 at 14:52
Yes, that is what I;'m using now, but it seems a bit redundant. @Aldert, both fetch IDs from the same table, which could be duplicate IDs. When I use this product for my Join later on, it could cause unwanted duplication (Inner Join).
– bo-oz
Mar 28 at 16:19
add a comment
|
Why are you worried about this? Do you use direct query?
– Aldert
Mar 28 at 14:46
I'm not sure if you can get M to useUNIONin its native query or not, but you can remove duplicate rows after aUNION ALLto get the same end result.
– Alexis Olson
Mar 28 at 14:52
Yes, that is what I;'m using now, but it seems a bit redundant. @Aldert, both fetch IDs from the same table, which could be duplicate IDs. When I use this product for my Join later on, it could cause unwanted duplication (Inner Join).
– bo-oz
Mar 28 at 16:19
Why are you worried about this? Do you use direct query?
– Aldert
Mar 28 at 14:46
Why are you worried about this? Do you use direct query?
– Aldert
Mar 28 at 14:46
I'm not sure if you can get M to use
UNION in its native query or not, but you can remove duplicate rows after a UNION ALL to get the same end result.– Alexis Olson
Mar 28 at 14:52
I'm not sure if you can get M to use
UNION in its native query or not, but you can remove duplicate rows after a UNION ALL to get the same end result.– Alexis Olson
Mar 28 at 14:52
Yes, that is what I;'m using now, but it seems a bit redundant. @Aldert, both fetch IDs from the same table, which could be duplicate IDs. When I use this product for my Join later on, it could cause unwanted duplication (Inner Join).
– bo-oz
Mar 28 at 16:19
Yes, that is what I;'m using now, but it seems a bit redundant. @Aldert, both fetch IDs from the same table, which could be duplicate IDs. When I use this product for my Join later on, it could cause unwanted duplication (Inner Join).
– bo-oz
Mar 28 at 16:19
add a comment
|
1 Answer
1
active
oldest
votes
The equivalent would be to add a Table.Distinct ( "Remove Duplicates" ) step, following the Table.Combine.
answered Mar 29 at 8:35
Mike HoneyMike Honey
12k1 gold badge14 silver badges32 bronze badges
Well the outcome might be the same... technically it introduces an extra select query around the union. Just looking for a way to avoid that, if possible.
– bo-oz
Mar 29 at 12:47
Oh well - good luck.
– Mike Honey
Mar 30 at 4:45
add a comment
|
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55399968%2fhow-to-append-queries-in-power-bi-power-query-with-union-instead-of-union-all%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The equivalent would be to add a Table.Distinct ( "Remove Duplicates" ) step, following the Table.Combine.
answered Mar 29 at 8:35
Mike HoneyMike Honey
12k1 gold badge14 silver badges32 bronze badges
Well the outcome might be the same... technically it introduces an extra select query around the union. Just looking for a way to avoid that, if possible.
– bo-oz
Mar 29 at 12:47
Oh well - good luck.
– Mike Honey
Mar 30 at 4:45
add a comment
|
The equivalent would be to add a Table.Distinct ( "Remove Duplicates" ) step, following the Table.Combine.
answered Mar 29 at 8:35
Mike HoneyMike Honey
12k1 gold badge14 silver badges32 bronze badges
Well the outcome might be the same... technically it introduces an extra select query around the union. Just looking for a way to avoid that, if possible.
– bo-oz
Mar 29 at 12:47
Oh well - good luck.
– Mike Honey
Mar 30 at 4:45
add a comment
|
The equivalent would be to add a Table.Distinct ( "Remove Duplicates" ) step, following the Table.Combine.
answered Mar 29 at 8:35
Mike HoneyMike Honey
12k1 gold badge14 silver badges32 bronze badges
The equivalent would be to add a Table.Distinct ( "Remove Duplicates" ) step, following the Table.Combine.
answered Mar 29 at 8:35
Mike HoneyMike Honey
12k1 gold badge14 silver badges32 bronze badges
answered Mar 29 at 8:35
Mike HoneyMike Honey
12k1 gold badge14 silver badges32 bronze badges
answered Mar 29 at 8:35
Mike HoneyMike Honey
12k1 gold badge14 silver badges32 bronze badges
answered Mar 29 at 8:35
Mike HoneyMike Honey
12k1 gold badge14 silver badges32 bronze badges
12k1 gold badge14 silver badges32 bronze badges
Well the outcome might be the same... technically it introduces an extra select query around the union. Just looking for a way to avoid that, if possible.
– bo-oz
Mar 29 at 12:47
Oh well - good luck.
– Mike Honey
Mar 30 at 4:45
add a comment
|
Well the outcome might be the same... technically it introduces an extra select query around the union. Just looking for a way to avoid that, if possible.
– bo-oz
Mar 29 at 12:47
Oh well - good luck.
– Mike Honey
Mar 30 at 4:45
Well the outcome might be the same... technically it introduces an extra select query around the union. Just looking for a way to avoid that, if possible.
– bo-oz
Mar 29 at 12:47
Well the outcome might be the same... technically it introduces an extra select query around the union. Just looking for a way to avoid that, if possible.
– bo-oz
Mar 29 at 12:47
Oh well - good luck.
– Mike Honey
Mar 30 at 4:45
Oh well - good luck.
– Mike Honey
Mar 30 at 4:45
add a comment
|
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55399968%2fhow-to-append-queries-in-power-bi-power-query-with-union-instead-of-union-all%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Why are you worried about this? Do you use direct query?
– Aldert
Mar 28 at 14:46
I'm not sure if you can get M to use
UNIONin its native query or not, but you can remove duplicate rows after aUNION ALLto get the same end result.– Alexis Olson
Mar 28 at 14:52
Yes, that is what I;'m using now, but it seems a bit redundant. @Aldert, both fetch IDs from the same table, which could be duplicate IDs. When I use this product for my Join later on, it could cause unwanted duplication (Inner Join).
– bo-oz
Mar 28 at 16:19