Share via

Prevent access from excel

mm 0 Reputation points
Sep 18, 2024, 1:04 PM

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,991 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,292 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 45,206 Reputation points
    Sep 19, 2024, 5:04 AM

    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,190 Reputation points
    Sep 19, 2024, 9:46 AM

    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.