Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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:
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.
Hi
Hi @Anonymous
The connection string would be
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.
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:
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |