Credentials

[Anonymous]

So there was a database that another user edited in SQL Server Management STudio to import data from into PowerBI

The PowerBI file was sent to me but I cannot access it because I don't have permissions to his SQL Server.

Does anyone know how to get rid of these security settings so I can access the data?

I tried changing the data source in the advanced query editor but I get an error

[Anonymous · Accepted solution]

I entered the wrong server name as defined in management studio.