Share via

Prevent access from excel

mm 0 Reputation points
2024-09-18T13:04:27.5766667+00:00

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

User's image

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?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,947 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,289 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 44,931 Reputation points
    2024-09-19T05:04:21.5966667+00:00

    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.

    0 comments
  2. MikeyQiaoMSFT-0444 3,190 Reputation points
    2024-09-19T09:46:45.8766667+00:00

    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.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.