Analyze in Excel and OLAP Pivot Table Extensions

[GigaFluxx]

I'm using the Analyze in Excel feture on a dataset but when I try to use the OLAP Pivot Table Extentions Add-In to filter, I get the following errors:

I've tried going to Authentication Settings and choosing both "Use the authenticated user's account" and "None" but neither worked.

As my data has thousands of lines, this add-in has been very useful in the past and I'm homping I can still use it with the more customized data I've setup.

[v-yangliu-msft]

Hi  @GigaFluxx  ,

For related content, you can check the following link:

https://stackoverflow.com/questions/53887525/ssas-claimstoken-is-not-supported

https://community.powerbi.com/t5/Desktop/Power-BI-datasets-Integrated-Security-ClaimsToken/m-p/84545...

Best Regards,

Liu Yang

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