SQL log in is failing when getting data from view

[Anonymous]

Hi,

I am trying to get data from a SQL view, through a blank query:

let
Input = Sql.Database("[server]",
"[database]",
[Query="EXEC dbo.View @StartDate='2018-03-01'"])
in
Input

Now Power BI asks me to fill in my credentials. But then I get the message that my credentials are not valid ("we couldn't authenticate..."), although I am 100% sure the credentials are correct (I use them all the time to import data from SQL into Power BI).

The server is only reachable through a VPN. Could that be a problem? 

[v-yuezhe-msft]

@Anonymous,

Do you select data from a view or execute a stored procedure? If you import data from SQL  view, the T-SQL should like "Select * from dbo.View". 

Are you able to connect to the SQL Server from SSMS and do you get expected result when you use the "EXEC dbo.View @StartDate='2018-03-01'  statement in SSMS? Please make sure that SSMS is installed in the same machine as Power BI Desktop.

We also need to know which authentication type you use in Power BI Desktop. If you use a Windows login to connect to SQL, please make sure you choose Windows authentication type, if you use a SQL login, choose database authentication type.

Regards,
Lydia