Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

RE: two query's on same databse

Hi @AIB,v-jiascu-msft , v-cherch-msft   i have two seperate query's    two execute.   so i have done below steps.   first  get data selected  sql server  then entered the servername and   advan...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Anonymous

     

    I don't think so. You could, after creating the first query in the query editor:

    1. Duplicate it

    2. In the duplicated query: go to the first Step: 'Source' and open it on the configuration sign on the right, that symbol looking like a tooth wheel

    3. Enter your SQL query 2 there.

     

    Maybe it will be a bit faster, but not by much.

AlB's avatar
AlB
Community Champion
7 years ago

Hi Anonymous

 

Can you show how  you entered the first query that you say is working fine?

Paste here the text you've used and explain where?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Ok,

    query 1

    select * from  vw.region ;  

     

    query2 

    select * from  vw.product;

     

    so   fresh Power bi application i opened. 

     

    step1:   get data

    step2:   sql server databse 

    step3:  enter servername 

    step4:  advanced

    step5  :  select * from  vw.region ;  

    step6:  username ,password.   

     

    step7   Query 1    i have 4,5 columns its coming perfectly.

     

     

    Now my question i have second query  if i want to execute  seond query do i need to follow above same steps or anyother way ?

    • AlB's avatar
      AlB
      Community Champion
      7 years ago

      Anonymous

       

      Can you not enter all the queries at once in the query editor? Under advanced option in the menu where you connect to the SQL server

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        so how to differenciate two queries there?