Unable to open the Tabular Model Designer due to Access denied.

Nurshara Mazlan 0 Reputation points


Last few weeks we had encountered an issue where all our cube was not able to be opened with an error access is denied. Besides that, we have also tried to open a cube from our local repo which also showed an error where access is denied. We have liaised with our organization's IT server team, and they have given us administration access but we still encounter the Access denied problem. This issue is highly urgent as we are unable to do any changes to our measures and continue our BAU. Feel free to let us know if you would like to request any more information. Your assistance is highly appreciated. Thank you.

2023-10-17 SSAS error message

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,231 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Greg Low 355 Reputation points Microsoft Regional Director

    Rather than using a specific workspace while developing, your life will be far better if you use the integrated workspace option in the AS projects.
    You are then unlikely to run into this sort of issue.

    0 comments No comments