Entering credentials for a SQL data source

[Dayna]

Hello,

I already have three local data source connections in my current file that use SQL, and normally when I add them by New Source > SQL Server, I get prompted to enter my SQL credentials.

I'm going through this through the same method, but PowerBI doesn't give me an opportunity to enter the SQL credentials, it goes from entering the server name and database name, directly to the screen to select the tables; of which, is empty, as it's not authenticated.

Can anyone assist? Is there a way to add a data source via a different method?

Any help you can offer would be appreciated.

Kind Regards,

Dayna

[v-chuncz-msft]

@Dayna ,

You may try to edit permissions in Data source settings.

[Dayna]

Hello,

It never actually creates the data source, so there's nothing in the 'Data Sources in Current File' for me to edit.

Many thanks,

Dayna