Forum Discussion
Stored Procedures in Direct Query mode
Hai, I am working in powerbi for 1(1/2) months. My client requirement is to use parameters in the report. I want to make it happen using direct query. Via import it is possible... For direct que...
"First connect to SQL using the Direct Query mode, then change the query to the following format in the Advanced editor.
SELECT * FROM OPENROWSET('SQLNCLI','server=<SQLservername>;Persist Security Info=True;UID=<SQLlogin>;PWD=<yourPassword>','EXEC <dbname>.<schema>.<storedprocedure>')"
Does this suggestion means that I cannot use the windows credentials as authentication method when connecting to SQL Server?