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,904 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,284 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 44,656 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 No comments

  2. MikeyQiaoMSFT-0444 3,025 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 No 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.