cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ppgandhi11 Member
Member

Is it possible to execute more than one SQL in power bi?

Hi,

 

I execute a sql statement to build my first universe and work off of it in power bi. During subsequent steps, I need to connect to database and execute another sql that would have parameter passed by the visual already created by first universe.

 

Is it possible to connect to database again and execute another sql ?  

4 REPLIES 4
Super User
Super User

Re: Is it possible to execute more than one SQL in power bi?

Hi @ppgandhi11,

 

This is possible in PBI however you have to use the advance editor to make the connection to different SQL and then make the merge or apppend of the two SQL queries, but is possible I use this in several of my reports.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




ppgandhi11 Member
Member

Re: Is it possible to execute more than one SQL in power bi?

@MFelix

 

Thanks for the reply. I am using Power BI Desktop July 2018 release. Can you please tell me how to go about it? screenshot would help about this functionality. I do not see anything that is called "advanced editor" at my end. Thanks again!

ppgandhi11 Member
Member

Re: Is it possible to execute more than one SQL in power bi?

The only advanced editor i see is in edit query section which i have already used. It has my original query that brings the universe of data. What i want is, to run another sql based on the visual I have created using original universe. I should be able to pass the field values to the new query and expect a new universe based on that. Thanks!

Super User
Super User

Re: Is it possible to execute more than one SQL in power bi?

Hi @ppgandhi11,

Yes I'm refering to the advance query editor and in there you can have more than one SQL.

However your post made me question what is your expected result. To what I could understand you have some data universe and based on that you have made some visuals now you want to pass the resultd from those visuals as a parameter a new SQL?

Is this correct? Can you please elaborate on what you are trying to do and expected results.

Regards,
MFelix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 156 members 1,632 guests
Please welcome our newest community members: