Forum Discussion
can't connect to SQL without admin rights?
I had recently done a prompted upgrade and my intution is that this upgrade improperly set a permission somewhere on the install files. I uninstalled power BI and did a fresh install and now sql DB access is working fine. Likely there is a bug in how the porgram is updating vs. a clean install.
Microsoft EmployeeWettowelReactor Where are you getting the error dialog? Can you take a screenshot?
I choose get data then SQL Server Database
Enter the database name (Entering a databse name makes no difference)
Short pause and then this.
Deleting the datasource from "options" -> "Data source settings" will repompt for credentials but will not change the error. entering normal domain credentials or admin credentials when Power BI was not launched with Admin rights will not change the error.
- pqian
Wow...the Details: "" really doesn't help. Maybe the trace will tell us something
Goto File->Options->Diagnostic and tick "Enable tracing", repeat the process again.
Look for files named Microsoft.Mashup.Container.* in the trace folder and see if anything helps? (or post them here)
Yes the error mesage is unhelpful. Here is the end of the trace after attempting again with one retry.
Here is the trace: http://pastebin.com/a8WpqrQS
I had recently done a prompted upgrade and my intution is that this upgrade improperly set a permission somewhere on the install files. I uninstalled power BI and did a fresh install and now sql DB access is working fine. Likely there is a bug in how the porgram is updating vs. a clean install.