Error while impersonating an user in SQL Server Analysis Services

  Hi folks, recently I came across an interesting issue related to impersonation in SSAS and I thought of sharing with you. Scenario and Issue: Let’s say we are trying to impersonate a user while browsing a cube in SSAS (Fig2). You might encounter with below error(Fig1). In first occurrence, it might feel like this…


Analysis Service 2016 Model gets corrupted if you add unsupported parameter while configuring the data source

Applies To: Tested on SQL Server Analysis Service 2016   Hello Everyone, today I am going to discuss about a known issue is Analysis Service 2016 Tabular Model. If you have built an Analysis Service tabular project and added some unsupported content in the data source, then neither you will able to open the Model from…


Accessing SSRS URL hosted on Azure VM over the Internet

There might be a requirement where you would like the SQL Server Reporting Services URL hosted on your on premise environment to be accessed over the Internet (outside of your domain). This can be achieved by hosting Reporting Services on an Internet-facing Web server to distribute general information to the public at large or private…