Forum Discussion

yoshihirok's avatar
yoshihirok
Icon for Post Prodigy rankPost Prodigy
10 years ago
Solved

Security Issues ? odc file connect may NOT limit by Row-level security

It's seems to security issue.   The odc file of 'Analyze of Excel' may not limit by Row-level security. Please re-check.   Repro step. 1. Publish pbix from Power BI Desktop as User A. 2. Sign ...
Need Help
  • IlanH's avatar
    IlanH
    10 years ago

    Analyze in Excel integration with Row-level security is coming soon - 2 weeks.

    I will update when it is available.

     

    Analyze in Excel integration with Row-level security means that Power BI service will apply Row-Level security to Excel connections to Power BI data sets

  • IlanH's avatar
    IlanH
    10 years ago

    Analyze in Excel integration with Row-level security is available.

IlanH's avatar
IlanH
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Analyze in Excel integration with Row-level security is available.

  • yoshihirok's avatar
    yoshihirok
    Icon for Post Prodigy rankPost Prodigy
    10 years ago

    Awesome, Awesome, Thank you, IlanH

     

    I will check Analyze in Excel integration with Row-level security.

     

    Regards,
    Yoshihiro Kawabata

    • yoshihirok's avatar
      yoshihirok
      Icon for Post Prodigy rankPost Prodigy
      10 years ago

      Hi IlanH.

       

      I can use "Analyze in Excel" and "Row-level security".

       

      My test step:

      1. By Power BI Desktop, I create a report.
      2. By Power BI Desktop, I publish the report to Power BI Service.
      3. By Power BI Service, I create a role in row-level security in security of the data set of the report.
      4. By Power BI Service, I test the role by "Test data as role".
      5. By Power BI Service, I create a dashbard from the report.
      6. By Power BI Service, I share the dashboard to a target account.
      7. By Power BI Service, I select "Analyze in Excel" of the report.
      8. By Excel, I connect Power BI Service as the taget account.
      9. By Excel, I check the data.

      It works nice

      I can share "Analyze with Excel" integrate with "Row-Level security" to our partners/customers/friends.

       

      Regards,
      Yoshihiro Kawabata

  • Rainar's avatar
    Rainar
    Icon for Advocate I rankAdvocate I
    8 years ago

    HIi! 

     

    Any info if its possible to implement RLS in an embedded solution? I'd like to create my own .odc file and then connect with using my embedded user.