Prevent access from excel

Question

I am looking to prevent access from Excel to my SSAS...

I have 10 cubes, and several PowerBI that consume from it... But I have some users that connect from excel and I want to prohibit that access. How can I prevent people accessing from excel?

Answer 1

How can I prevent people accessing from excel?

You simply can't

MS Excel is a client application as any other and SSAS don't differ between what application it is.

And what could that be good for?

MS Excel is a very common and execellent for data analysis.

Answer 2

Hi，mm

You cannot block connections by client type, this is the relevant Thread.

https://learn.microsoft.com/en-us/answers/questions/1144345/how-to-prevent-access-to-ssas-analyze-in-excel-fea

https://learn.microsoft.com/en-us/answers/questions/263973/restrict-prevent-ad-hoc-conections-to-ssas-models

Regards

Mikey Qiao

---

If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.