topic Re: Cannot share content with external user (data connection : OData & SQL Server) in Report Server

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

sylpel — Thu, 14 Nov 2019 19:57:17 GMT

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.

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
I enabled the Share content with external users feature in the Power BI admin portal
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

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

KBO — Fri, 15 Nov 2019 18:43:31 GMT

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

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

sylpel — Sat, 16 Nov 2019 14:04:25 GMT

Thank you Kathrin for you reply,

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

Sylpel

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

KBO — Sat, 16 Nov 2019 14:31:01 GMT

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

Best, Kathrin

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

sylpel — Mon, 18 Nov 2019 16:51:20 GMT

Hello Kathrin,

I try this as well and it still not working 😞

Sylpel

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

KBO — Mon, 18 Nov 2019 19:37:44 GMT

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

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

sylpel — Tue, 19 Nov 2019 09:05:28 GMT

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