Power BI Desktop - Get Data - Access Denied

[jwilli14]

Power BI desktop was working fine;  I could get data from excel,  sqlserver, and oracle and generate visuals.

Now whenever I try Get Data,  I get Access Denied?????  Any ideas?

[jwilli14]

Thanks for the reply.   But this is only for editing prior connections.  I cannot get data from an excel spreadsheet on my c drive.  Where do you set the credential for that?

[ajnovillo]

Hi

I have the exast same issue but when accesing any kind of source (excel or SQL Server). I've removed the credentials but it's the same. After selecting the name of the SQL Server, it gives access denied.

If I uninstall and install the application again, it works for a time, but the next I have the same issue. After reinstalling I create a link to some tables, and today when I try to modify the queries or to reload the data, if fails with the Access Denied error. It looks similar to pressing the Deny button when the privilage are elevated. Looks like the application rememberes a denial ¿?.

Regards

[jwilli14 · Accepted solution]

I do not have local admin rights to my computer based on company policy;  I assume you do not either.

But local desktop installed Avecto on my machine which gives me elevated priviledges.  That has solved my problem.

You need to elevate your priviledges.   Good luck!

[claireallen1]

Hello @Jw 

Can you help,

A user in our company has been using Power Bi without any issues until they changed their user password and now they are not able to access some of the folders / lists they have already created a connection to, they receive the message access denied.

We are not sure what Avecto is and whether they need to install it or not

Any suggestions would help to resolve this issue, I have tried to connect to the same data and I do not have any issues.

Thank you

Claire

[Anonymous]

Hello @jwilli14

Did you change your user account (password) recently?

Perhaps you could check your datasource credential setting. There are available in the desktop. Here :

after that, you should see all your data connection and modifiy the credential if needed :

Hope it help you

Sébastien