Forum Discussion
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 advanced entered first query.
then username password .query is executed and table is created for that single query,
so now i have other query - where i need to run the second query?
again i need to go get data -select sql server -enter credentials? is there any other options to execute mutiple query's?
please guide me
Best
Chanty
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.
8 Replies
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?
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 ?
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