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