Forum Discussion
Power BI Desktop - Get Data - Access Denied
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?
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!
5 Replies
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
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?
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
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!
