Power BI Exchange

Hi
I have the need to show two results from two separate sql queries, I have worked out.  The queries dont relate to each other, but the values are a comparison of two items that need to be presented on one page.  Do the two queries have to be related? Or can I have the two separate queries in one report without issue?

Thanks in advance
Dean-O

------------------------------
Dean-O Rochester
Programmer Developer
------------------------------

Hi,

Not sure to understand your needs, but yes you can have 2 queries that are not related on the same page.
If you mean the same visuals (table or graph) and not the same page, then you need at least to have something in common and a relation.

Hope it helps...

------------------------------
Olivier
------------------------------

Original Message:
Sent: Feb 19, 2021 11:25 AM
From: Dean-O Rochester
Subject: can one report have two queries that are not joined

Hi
I have the need to show two results from two separate sql queries, I have worked out.  The queries dont relate to each other, but the values are a comparison of two items that need to be presented on one page.  Do the two queries have to be related? Or can I have the two separate queries in one report without issue?

Thanks in advance
Dean-O

------------------------------
Dean-O Rochester
Programmer Developer
------------------------------

Hi
Yes I just want to put two separate queries on the same report and then have graphs from each  showing things on the screen, but not related via a slicer, etc
Thanks
Dean-O

------------------------------
Dean-O Rochester
Programmer Developer
------------------------------

Original Message:
Sent: Feb 22, 2021 05:58 AM
From: Olivier Aillery
Subject: can one report have two queries that are not joined

Hi,

Not sure to understand your needs, but yes you can have 2 queries that are not related on the same page.
If you mean the same visuals (table or graph) and not the same page, then you need at least to have something in common and a relation.

Hope it helps...

------------------------------
Olivier

Original Message:
Sent: Feb 19, 2021 11:25 AM
From: Dean-O Rochester
Subject: can one report have two queries that are not joined

Hi
I have the need to show two results from two separate sql queries, I have worked out.  The queries dont relate to each other, but the values are a comparison of two items that need to be presented on one page.  Do the two queries have to be related? Or can I have the two separate queries in one report without issue?

Thanks in advance
Dean-O

------------------------------
Dean-O Rochester
Programmer Developer
------------------------------

Hi,

So just create your first query, then add a second Source for your other query (button Get Data)
Once your 2 queries are made, just create your visuals selecting Fields from one, or the other one query.
Is that OK or do you have any further questions ?

------------------------------
Olivier
------------------------------

Original Message:
Sent: Feb 22, 2021 08:45 AM
From: Dean-O Rochester
Subject: can one report have two queries that are not joined

Hi
Yes I just want to put two separate queries on the same report and then have graphs from each  showing things on the screen, but not related via a slicer, etc
Thanks
Dean-O

------------------------------
Dean-O Rochester
Programmer Developer

Original Message:
Sent: Feb 22, 2021 05:58 AM
From: Olivier Aillery
Subject: can one report have two queries that are not joined

Hi,

Not sure to understand your needs, but yes you can have 2 queries that are not related on the same page.
If you mean the same visuals (table or graph) and not the same page, then you need at least to have something in common and a relation.

Hope it helps...

------------------------------
Olivier

Original Message:
Sent: Feb 19, 2021 11:25 AM
From: Dean-O Rochester
Subject: can one report have two queries that are not joined

Hi
I have the need to show two results from two separate sql queries, I have worked out.  The queries dont relate to each other, but the values are a comparison of two items that need to be presented on one page.  Do the two queries have to be related? Or can I have the two separate queries in one report without issue?

Thanks in advance
Dean-O

------------------------------
Dean-O Rochester
Programmer Developer
------------------------------

Original Message:
Sent: 2/22/2021 8:59:00 AM
From: Olivier Aillery
Subject: RE: can one report have two queries that are not joined

Hi,

So just create your first query, then add a second Source for your other query (button Get Data)
Once your 2 queries are made, just create your visuals selecting Fields from one, or the other one query.
Is that OK or do you have any further questions ?

------------------------------
Olivier
------------------------------

Original Message:
Sent: Feb 22, 2021 08:45 AM
From: Dean-O Rochester
Subject: can one report have two queries that are not joined

Hi
Yes I just want to put two separate queries on the same report and then have graphs from each  showing things on the screen, but not related via a slicer, etc
Thanks
Dean-O

------------------------------
Dean-O Rochester
Programmer Developer

Original Message:
Sent: Feb 22, 2021 05:58 AM
From: Olivier Aillery
Subject: can one report have two queries that are not joined

Hi,

Not sure to understand your needs, but yes you can have 2 queries that are not related on the same page.
If you mean the same visuals (table or graph) and not the same page, then you need at least to have something in common and a relation.

Hope it helps...

------------------------------
Olivier

Original Message:
Sent: Feb 19, 2021 11:25 AM
From: Dean-O Rochester
Subject: can one report have two queries that are not joined

Hi
I have the need to show two results from two separate sql queries, I have worked out.  The queries dont relate to each other, but the values are a comparison of two items that need to be presented on one page.  Do the two queries have to be related? Or can I have the two separate queries in one report without issue?

Thanks in advance
Dean-O

------------------------------
Dean-O Rochester
Programmer Developer
------------------------------

Nice to hear :-)
Do not forget to close your post and mark it as solved.

Thanks and have a nice day

------------------------------
Olivier
------------------------------

Original Message:
Sent: Feb 22, 2021 12:48 PM
From: Dean-O Rochester
Subject: can one report have two queries that are not joined

Kool that works. Thanks 

Dean-O

Sent from my Droid-iPodPad-Berry

Original Message:
Sent: 2/22/2021 8:59:00 AM
From: Olivier Aillery
Subject: RE: can one report have two queries that are not joined

Hi,

So just create your first query, then add a second Source for your other query (button Get Data)
Once your 2 queries are made, just create your visuals selecting Fields from one, or the other one query.
Is that OK or do you have any further questions ?

------------------------------
Olivier

Original Message:
Sent: Feb 22, 2021 08:45 AM
From: Dean-O Rochester
Subject: can one report have two queries that are not joined

Hi
Yes I just want to put two separate queries on the same report and then have graphs from each  showing things on the screen, but not related via a slicer, etc
Thanks
Dean-O

------------------------------
Dean-O Rochester
Programmer Developer

Original Message:
Sent: Feb 22, 2021 05:58 AM
From: Olivier Aillery
Subject: can one report have two queries that are not joined

Hi,

Not sure to understand your needs, but yes you can have 2 queries that are not related on the same page.
If you mean the same visuals (table or graph) and not the same page, then you need at least to have something in common and a relation.

Hope it helps...

------------------------------
Olivier

Original Message:
Sent: Feb 19, 2021 11:25 AM
From: Dean-O Rochester
Subject: can one report have two queries that are not joined

Hi
I have the need to show two results from two separate sql queries, I have worked out.  The queries dont relate to each other, but the values are a comparison of two items that need to be presented on one page.  Do the two queries have to be related? Or can I have the two separate queries in one report without issue?

Thanks in advance
Dean-O

------------------------------
Dean-O Rochester
Programmer Developer
------------------------------

Hi,

Can you please close this subject (mark it as solved), so that other user can find it.
Thanks in advance for your cooperation and have a nice week.

------------------------------
Olivier
------------------------------

Original Message:
Sent: Feb 22, 2021 12:48 PM
From: Dean-O Rochester
Subject: can one report have two queries that are not joined

Kool that works. Thanks 

Dean-O

Sent from my Droid-iPodPad-Berry

Original Message:
Sent: 2/22/2021 8:59:00 AM
From: Olivier Aillery
Subject: RE: can one report have two queries that are not joined

Hi,

So just create your first query, then add a second Source for your other query (button Get Data)
Once your 2 queries are made, just create your visuals selecting Fields from one, or the other one query.
Is that OK or do you have any further questions ?

------------------------------
Olivier

Original Message:
Sent: Feb 22, 2021 08:45 AM
From: Dean-O Rochester
Subject: can one report have two queries that are not joined

Hi
Yes I just want to put two separate queries on the same report and then have graphs from each  showing things on the screen, but not related via a slicer, etc
Thanks
Dean-O

------------------------------
Dean-O Rochester
Programmer Developer

Original Message:
Sent: Feb 22, 2021 05:58 AM
From: Olivier Aillery
Subject: can one report have two queries that are not joined

Hi,

Not sure to understand your needs, but yes you can have 2 queries that are not related on the same page.
If you mean the same visuals (table or graph) and not the same page, then you need at least to have something in common and a relation.

Hope it helps...

------------------------------
Olivier

Original Message:
Sent: Feb 19, 2021 11:25 AM
From: Dean-O Rochester
Subject: can one report have two queries that are not joined

Hi
I have the need to show two results from two separate sql queries, I have worked out.  The queries dont relate to each other, but the values are a comparison of two items that need to be presented on one page.  Do the two queries have to be related? Or can I have the two separate queries in one report without issue?

Thanks in advance
Dean-O

------------------------------
Dean-O Rochester
Programmer Developer
------------------------------