SQL BI / Data Access Technologies

( SSIS, SSRS, SSAS, Data Access, POWER BI, PBI RS, Azure AS, SSMA, LINQ, System.Data ... )

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...

Date: 05/28/2018

Invalid Column __$command_id issue during CDC implementation in SSIS package

In this blog, we will be addressing the problem with CDC implementation in SSIS package which goes...

Date: 05/14/2018

Proactive caching with in-Memory tables as notification

Recently we encountered an issue using a Multidimensional Model where ROLAP and proactive caching...

Date: 04/09/2018

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...

Date: 04/09/2018

SSAS translation for client application

Tested on: Excel 2013, Excel 2016, Reporting Services 2012/2014/2016. Hello Everyone, in this blog I...

Date: 04/06/2018

Configure Oracle data source for SQL Server Reporting Services (SSDT and Report Server)

In general, there are several links available to download the ODAC components from the Oracle...

Date: 03/26/2018

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....

Date: 02/26/2018

“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...

Date: 02/26/2018

Using Amazon RedShift with Power BI

Over this blog, I would like to address on how to install the Amazon Redshift Driver on Windows...

Date: 02/26/2018

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...

Date: 01/16/2018

Flat file connection manager doesn't work for rows containing "Embedded Qualifiers"

I came across an interesting issue related to Flat file connection manager which doesn't work for...

Date: 12/29/2017

SSIS packages executed through SQL Agent Job scheduler fails while connecting to Azure File Storage Path

Recently we ran into an interesting scenario where we had a SSIS package that contained a script...

Date: 12/01/2017

SSIS Scale Out worker is not showing up in Worker Agents

Understanding of the issue: Adding the scale out worker to the master shows successful but this does...

Date: 12/01/2017

“Unexpected error from external database driver (1). (Microsoft JET Database Engine)" after applying October security updates.

UPDATE: As informed, the security patches with the fix was rolled-out yesterday 11/14. We would...

Date: 10/18/2017

ARM Resource Manager Template Deployment with Azure Analysis Services

Analysis Services model can be deployed in Azure in different ways like from SSDT or by running the...

Date: 09/27/2017

How to display report parameter Label field in RDLC reports

While working on customer issue recently, I came across following scenario where there was a problem...

Date: 09/22/2017

Reporting Services Web Services with .NET CORE 2

Any application built using .NET CORE SDK can be executed on any platform (Windows, Linux &...

Date: 09/19/2017

SQL Server Reporting Services 2016 Integration with an Application

There are multiple ways to integrate or embed SQL Reporting Services Report in an application. This...

Date: 09/15/2017

Automating Azure Analysis Service Processing using Azure Automation Account

Analysis Services has been progressing day-by-day with new exciting features and there is an ask...

Date: 09/01/2017

SSRS – Bing Maps seem to be broken with latest changes in Bing Map Service

Reporting Services Reports that contain Bing Maps seem to broken due to a change in the Bing Map...

Date: 08/04/2017

OData source connection manager to PWA (Project Web App) - Project Online URL fails with "(401) Unauthorized"

Over this blog, I would like to discuss about one of the interesting issues that we had worked upon...

Date: 08/01/2017

Dynamically enable or disable the report printing option on the client side

Hello Everyone, in this blog I am going to discuss about an interesting scenario while working on a...

Date: 07/07/2017

KPI Goal format not working in SQL Server Analysis Service Tabular project

While working on customer issue recently, came across following scenario where there was a problem...

Date: 05/31/2017

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...

Date: 05/30/2017

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...

Date: 05/15/2017

Issue in getting cached data for a data driven subscription when created with an expiry schedule

Applies To: Tested on SQL Server Reporting Services 2008 and 2008 R2. In this blog, I would like to...

Date: 05/15/2017

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...

Date: 04/10/2017

Creating dynamic SSIS package [Object model] and using OleDBSource & OleDBDestination internally fails in SSIS 2016

Issue: While dynamically creating SSIS packages using the object model and referencing the following...

Date: 12/29/2016

How a non-Admin users of SSIS 2012/2014 can view SSIS Execution Reports

There can be few scenarios where the requirement demands to have Full permission for the developers...

Date: 12/29/2016

Connecting to SQL Server Using PowerShell

In this blog, I would like to show you how we can connect to a SQL Server Instance using PowerShell...

Date: 11/30/2016

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The Local Security Authority cannot be contacted)

Symptoms: Connections to the SQL Server fails after certain windows update and getting the below...

Date: 11/30/2016

Intermittent JDBC Connectivity issue - The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: SQL Server returned an incomplete response. The connection has been closed

Symptoms: When connections are repeatedly made to SQL Server, one can observe about ~ 1% of...

Date: 11/30/2016

Running SSIS packages outside the Developer tools using DTEXEC.exe without installing the Integration services.

In this blog, I would like to address one of the important information about SQL Server Integration...

Date: 10/28/2016

SSAS cube design errors while creating data source views for Teradata tables with columns having default date constraint

Issue: While trying to create a data source view (DSV) on the SSAS project connecting to a Teradata...

Date: 10/28/2016

Date format Issues in SSIS Packages between MM/dd/yyyy & dd/MM/yyyy

In this blog, I would like to address one of the interesting issues that I came across recently with...

Date: 10/28/2016

Loading SSAS Tabular Databases in SSMS fails for Non-admin users with “Failed to retrieve data for this request”

I was working with one of my customers where he came across the following issue. I thought of...

Date: 10/19/2016

Migrating Oracle to SQL Server using SSMA – Error: Cannot find either column "ssma_oracle" or the user-defined function or aggregate "ssma_oracle.rpad_varchar"

Issue: You are trying to migrate server objects and data from Oracle to SQL Server using SSMA for...

Date: 10/19/2016

SSAS (ROLAP) with Azure SQL Data Warehouse

Let's consider you are using SQL Server Analysis Services in MOLAP (Multi-Dimensional Online...

Date: 09/26/2016

Enable TLS 1.2 protocol for Reporting Services with custom .NET application

If you are using any custom application which is integrated with any payment gateway you might be...

Date: 07/12/2016

ODBC Driver 11 and above fails with Output parameter of type SQL_VARIANT

Problem: If you have an application which is using ODBC driver 11 or above and is executing a stored...

Date: 06/29/2016

A new release of ODBC for Modern Data Stores

After more than 15 years since the last release, Microsoft is looking at updating the Open Data Base...

Date: 06/07/2016

Connection timeout issue with .NET Framework 4.6.1 - TransparentNetworkIPResolution

Understanding of the issue: Client application using .NET Framework 4.6.1 fails to connect to SQL...

Date: 05/07/2016

How to perform a silent installation with SQL Server Migration Assistant (SSMA)

In this blog, I would like to discuss about how we can perform a silent installation (without...

Date: 05/06/2016

SQLCMD 2014 fails to authenticate via Kerberos

Understanding of the issue: When we try to execute a query on a SQL server from a remote machine...

Date: 04/27/2016

The OLE DB provider "MSDASQL" for linked server " " supplied inconsistent metadata for a column.The column " " (compile-time ordinal 2) of object " " was reported to have a "DBCOLUMNFLAGS_ISLONG" of 0...

Applies To: SQL 2012 and above. (Requires supportability towards Multi-Subnet Failover)...

Date: 07/23/2015

Error while connecting to SQL Server – “Could not connect because the maximum number of '1' user connections has already been reached.”

Applies To: Tested on SQL Server 2008, 2008 R2, 2012 and 2014. Issue: In this blog, I would like...

Date: 07/21/2015

Report Manager: “System.InvalidOperationException: This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms.”

Applies To: Tested on SQL Server Reporting Services 2008, 2008 R2, 2012 and 2014. When you browse...

Date: 07/16/2015

Import / Deployment / Execution of SSIS packages fails after you migrate SSISDB from SQL Server 2012 to SQL Server 2014.

In this blog, I would like to discuss about one of the interesting scenarios that you would witness...

Date: 07/09/2015

[“… an error occurred during the pre-login handshake.” & “DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error” when connecting to SQL Server.

This blog is regarding one of most commonly faced issues that you may receive when connecting to the...

Date: 07/09/2015

SSIS Packages executed from Visual Studio Business Intelligence Development Studio - BIDS [Design time] on a 64bit development server goes to unresponsive state during package execution.

Through the use of this blog, I would like to address a common scenario that you would run into when...

Date: 05/21/2014

Next>