Forum Discussion
can't connect to SQL without admin rights?
- 10 years ago
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.
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
- WettowelReactor10 years agoNew Member
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.
- Tas10 years agoAdvocate IThanks, I was tearing my hair out (what is left of it) trying to figure the same problem out. The very useful "" error message doesn't help a lot does it. Your Uninstall/Reinstall solution worked perfectly. I had done a download / install of a new version to try and fix the problem too, but that didn't work. Only an uninstall/re-install did. Thanks again.
- sdjensen10 years agoSolution Sage
It helps deleting all data sources and then close Power BI Desktop and reopen.