Forum Discussion
Solved
Cannot share content with external user (data connection : OData & SQL Server)
Hello dear community, I would like to share a power bi report with an external user (outside our domain) but it doesnt work:; the data source is from our SQL server (GP) and dynamics CRM. ...
- Hi, which connection do you have in the Report: - Direct Query -Import ? If you have direct query the external user can't see anything because of the security of the DB. In Import mode it should work. Best, Kathrin
Ok, have you give the permission also direct on the report? Maybe that is the problem.
Best, Kathrin
Hi Katrin,
Thanks for your help. I finally succeeded! I had to create an app and allow the user to connect to the underlying data.
Thank you!
sylpel
Hi, which connection do you have in the Report: - Direct Query -Import ? If you have direct query the external user can't see anything because of the security of the DB. In Import mode it should work. Best, Kathrin
Thank you Kathrin for you reply,
Unfortunately I am in Import mode . Therefore my problem is elsewhere.
Sylpel
Ok, have you give the permission also direct on the report? Maybe that is the problem.
Best, Kathrin