Analyze in Excel using Row Level Security - RLS (Option not available)

[Anonymous]

Hello, 

When I "Publish to Power BI" from a desktop file (with Row-level Security in place) to a Power BI online workspace, and then test the "row-level security" within the Power BI online workspace, the "Analyze in Excel" option is not available. What am I missing?

See below screenshot: 

I have Power BI Pro and am publishing it to my own workspace, so I have permissions within the workspace. 

Thanks!

[V-lianl-msft]

Hi @Anonymous ,

Is this problem sloved?
If not, please let me know.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[V-lianl-msft]

Hi @Anonymous ,

Please make sure that this option is enabled in tenant settings and refer to this document if the problem persists.

service-analyze-in-excel#requirements 

troubleshooting-analyze-in-excel 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ibarrau]

Hi. Can you explain where do you think Analyze in excel should be? there is something odd about the explanation because you can't publish to web a report with RLS configured in its dataset.

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web#limitations

Are you able to analyze in excel a different report in your organization?

Regards,

[Anonymous]

Hello! 

This is not for publishing to the web. This is to utilize in the Power BI online workspace.