Connecting from SSRS 2016 to SSAS using HTTP/MSMDPump and Basic Authentication – “Object reference not set to an instance of an object”

  After upgrading to SSRS 2016 SP1 CU8, or SSRS 2016 SP2, you might see the following error when running reports or connecting to a SSAS data source using HTTP/MSMDPump with Basic Authentication, “Object reference not set to an instance of an object.”     If you look in the Report Server Error logs, you’ll…


Proactive caching with in-Memory tables as notification

  Recently we encountered an issue using a Multidimensional Model where ROLAP and proactive caching were enabled on one of the partition. The notification was set to SQL Server table to track the changes and refresh the cache.   The behavior we noticed was that if a SQL Server Table was set to a Memory…


Dynamic RLS support for Analysis Service Tabular Model based on multiple roles for each user

Tested on: SQL Server Analysis Service 2016 Tabular, Azure Analysis Service.   Hello everyone, I am sure that whenever you wanted to implement Row Level Security(RLS) for Analysis Services Tabular Mode you might be wondering how I will implement RLS when some of my user has multiple roles assigned. Well here is the solution for…


SSAS translation for client application

Tested on: Excel 2013, Excel 2016, Reporting Services 2012/2014/2016.   Hello Everyone, in this blog I will discuss on how to view SSAS translation in different client Application.   Before I begin with the details on this blog, if anyone doesn’t know what Translation in SSAS is, then I request you to go and check…


You cannot publish more than 200 Dataset/Report together within an Workspace in Power BI service

  We have come across an interesting scenario recently while working on one of the customer issues. The issue was not being able to publish the PBIX file to Power BI service in one particular workspace.   The Power BI Desktop shows below error while publishing to service:   Error message:   Well to give…


“Pivot Table Operation failed. We cannot locate a server to load the workbook Data Model” error when applying filter in Excel workbook accessed through Power BI Report server

  Scenario and Issue: – After configuring (by following https://docs.microsoft.com/en-us/power-bi/report-server/excel-oos article) Power BI Report Server to use Office Online Server (OOS) to host the Excel PowerPivot models, when you open the Excel workbook which has the PowerPivot model and try to apply filter or slicer, you get the below mentioned error.   Error: -Pivot Table…


Using Amazon RedShift with Power BI

  Over this blog, I would like to address on how to install the Amazon Redshift Driver on Windows Operating System and how to configure the Data Source Name(DSN) to be used with Power BI.   Creating a System DSN Entry for an ODBC Connection on Microsoft Windows.   After you download and install the…


TLS Issue with SSIS package while accessing OData Source like Dynamics AX Online

  I have come across an interesting scenario recently while working on one of the customer issues. The SSIS package fails during the execution, even though the Test Connection and Preview Data in the OData Source Task succeeds while connecting to the Dynamics AX OData Source. Here is the error message we got: [OData Source…