Forum Discussion

sylpel's avatar
sylpel
Frequent Visitor
6 years ago
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.   ...
Share restricted data
  • KBO's avatar
    KBO
    6 years ago
    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's avatar
    KBO
    6 years ago

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

    Best, Kathrin

  • sylpel's avatar
    sylpel
    6 years ago

    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

     

sylpel's avatar
sylpel
Frequent Visitor
6 years ago

Hello Kathrin,

I try this as well and it still not working 😞

 

Sylpel

KBO's avatar
KBO
Memorable Member
6 years ago
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's avatar
    sylpel
    Frequent Visitor
    6 years ago

    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