Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

can one report have two queries that are not joined

Jump to Best Answer
  • 1.  can one report have two queries that are not joined

    Bronze Contributor
    Posted 17 days ago
    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
    ------------------------------


  • 2.  RE: can one report have two queries that are not joined
    Best Answer

    Silver Contributor
    Posted 14 days ago
    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
    ------------------------------



  • 3.  RE: can one report have two queries that are not joined

    Bronze Contributor
    Posted 14 days ago
    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
    ------------------------------



  • 4.  RE: can one report have two queries that are not joined

    Silver Contributor
    Posted 14 days ago
    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
    ------------------------------



  • 5.  RE: can one report have two queries that are not joined

    Bronze Contributor
    Posted 14 days ago
    Kool that works. Thanks 

    Dean-O

    Sent from my Droid-iPodPad-Berry





  • 6.  RE: can one report have two queries that are not joined

    Silver Contributor
    Posted 13 days ago
    Nice to hear :-)
    Do not forget to close your post and mark it as solved.

    Thanks and have a nice day

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



  • 7.  RE: can one report have two queries that are not joined

    Silver Contributor
    Posted 7 days ago
    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
    ------------------------------