How can we add multiple T-Sql queries under one connection in PBI Desktop

[wasim123]

Hello All, I'm relatively new to Power BI.

I am creating a PBI report for which I need to write mutiple Sql queries to get my dim and fact tables.

I'm creating a new connection everytime to write my sql query, is there any option by which I can write sql query in existing connection rather than creating new connection everytime.

Like in SSRS where you create one connection and can add many dataset under that connection.

Note:- When I select existing connection it is taking me to Table/view names and there I'm not finding any option for wrtitng sql query. 

[mohammedadnant]

Hi @wasim123 

Good day,

If you create view in SQL and then use in Power BI then, 

you have an option to use existing connection, it is under Home Tab on top ribbon --> Recent Sources

you can select the recent connected sources in Power BI,

Thanks & Regards,

Mohammed Adnan

https://www.youtube.com/c/taik18

[wasim123]

Thank you, but in recent sources it takes you to directly tables/view where you don't get any option of writing sql queries, writing sql queries option appears at time of making new connection.

[v-lionel-msft]

Hi @wasim123 ,

As tested, current version is impossible to realize the idea.

Please submit your idea.

Ideas (powerbi.com)

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@wasim123 , I think if you want to give query then you can give it while creating a connection.

Refer to this video from guyinacube to use parameter for connection -https://www.youtube.com/watch?v=XIq5vN5oPf8