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 ?