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.

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