Forum Discussion

cheid1977's avatar
cheid1977
Icon for Advocate I rankAdvocate I
9 years ago

Problems sending Power BI Desktop to others while connected to SQL Server

I created a dashboard through Power BI Desktop that was connected a SQL Server. I sent the dashboard others in my department who also are connected to the SQL Server, but for some reason the dashboar...
Need Help
cheid1977's avatar
cheid1977
Icon for Advocate I rankAdvocate I
9 years ago

I tried that and it tells me the user is not authorized.  I have verified that they have access to the connected server.  I also tried accessing the database and get "Impersonation is not suppoerted in DirectQuery mode. Turn off impersonation or swith to import mode".  I am not sure how to turn of impersonation mode. I am at a lost on what is keeping my department from accessing the server via the BI desktop file I sent them over e-mail.

tonysellars's avatar
tonysellars
Icon for Advocate II rankAdvocate II
9 years ago

If the users which you are sending to have access to the database source same as you do then make sure that on the screen following the steps outline previously that you are not actually entering credentials but using your current credentials (i.e. trusted connection).  If the team of people you are sharing with is all using a sql login, then make sure the credentials are correct on the database tab.