Is it posible to invoke an stored procedure directly from the ConnectionString?

[Anonymous]

Hi all,

Is it posible to invoke an stored procedure directly from the ConnectionString?

This is an example of my Connection String:

- Data Source=SERVERNAME;

- User Id=myUsername;Password=myPassword;

Is it posible to do the following?

Data Source=SERVERNAME;

User Id=myUsername;Password=myPassword;Invoke='EXEC SP_PROCEDURE'

Thank you.

[v-juanli-msft]

Hi 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[v-juanli-msft]

Hi @Anonymous 

The connection string would be

1. let  
2.   
3. Source = Sql.Database("DHRUVIN\SQLEXPRESS", "WMS_201", [Query="EXEC stored procedure "])  
4.   
5. in  
6.   
7. Source

But i don't see any method to write the password in the connection string, it is easy with a direct way as my last post shown.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

When connecting to Database like SQL SERVER, you can find the connector in Power BI Desktop,

Select Get data->SQL SERVER-> enter server name/database name, expand "Advanced option", enter the"EXEC stored procedure name" in the "SQL Statement" window.

Reference:

https://community.dynamics.com/crm/b/crmchap/posts/utilising-sql-server-stored-procedures-with-powerbi

Execute SQL Server Stored Procedure With User Parameter In Power BI

After clicking on "ok", it will pop out a window where you can select authetication to connect to the database.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.