Forum Discussion
Unable to Connect to SQL Server
Hello,
I just wanted to add my experience to this. As the Network Manager, I was not comfortable allowing a user to run with admin credentials, so I wanted to find a way around this issue.
I also did have to use Run As Admin to get the connection to work. I discovered that I only needed to do that to establish the connection, though. Once I did, the program could then be run without the Run As Admin option and it would work.
Hope that helps someone.
As the error message mentioned, it seems a permission issue when loading the assembly, please try to run Power BI Desktop as administrator. If it still doesn't work, please repair your .NET Framework, restart your server and try again to see if it works.
Regards,
Dear v-sihou-msft ,
It worked for me running as administrator. But is there a way to make it work with a regular user?
I´m using the admin credentials for SQL connection, but wanted to run PowerBI Desktop with regular user.
Thank you,
Eduardo
Hello,
I just wanted to add my experience to this. As the Network Manager, I was not comfortable allowing a user to run with admin credentials, so I wanted to find a way around this issue.
I also did have to use Run As Admin to get the connection to work. I discovered that I only needed to do that to establish the connection, though. Once I did, the program could then be run without the Run As Admin option and it would work.
Hope that helps someone.
Helped me, thank you :)
Yes it worked for me too
Thank you. Run as admin worked for me.
Yes right click and run as administrator solves the problem. But running the pbix as admin prevents from saving the file on network drive. Thats the only problem.
