Cannot share content with external user (data connection : OData & SQL Server)

[sylpel]

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.

1. I have followed the required steps to share content with external users : https://docs.microsoft.com/en-us/power-bi/service-admin-azure-ad-b2b
2. I enabled the Share content with external users feature in the Power BI admin portal
3. I also sent the invite using the Azure portal or PowerShell.

4. I even added them to our report through the share UI

5. I added the external user in my workspace (even though external users cannot access others worspace)

6. The user has an pro license.

Please help!

Thanks

Sylpel

[KBO · Accepted solution]

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

[KBO · Accepted solution]

Ok, have you give the permission also direct on the report? Maybe that is the problem.

Best, Kathrin

[KBO · Accepted solution]

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

[sylpel]

Thank you Kathrin for you reply,

Unfortunately I am in Import mode . Therefore my problem is elsewhere.

Sylpel

[KBO · Accepted solution]

Ok, have you give the permission also direct on the report? Maybe that is the problem.

Best, Kathrin

[sylpel]

Hello Kathrin,

I try this as well and it still not working 😞

Sylpel

[KBO]

Hmmm...is there any RLS on the Report? Otherwise I would load the report again to the service and share it. May be its a bug... Best Kathrin

[sylpel · Accepted solution]

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