Reporting Services Web Services with .NET CORE 2

  Any application built using .NET CORE SDK can be executed on any platform (Windows, Linux & Mac). But due to this there are a lot of APIs available in .NET Framework that are no longer available in .NET CORE. One of the missing APIs is Web Service (SOAP) Clients. The way to move forward…


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 can be achieved via:- URL Access Method Using SOAP APIs Using Report Viewer Control Couple of common issue that we face while calling reports in an application are: – How to pass credentials from application to SSRS. How to…


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 from the users to automate the Azure Analysis Services Processing. There are few ways which we can automate the processing. Using the conventional way what we have for the On-Prem. Using SQL Agent Job/ Using AMO Objects/ Using PowerShell….


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 APIs. From the initial analysis, Bing Maps SOAP web service seems to be shut down after July 31, 2017. When we access the Bing Maps API from SSRS we are calling into this method http://dev.virtualearth.net/webservices/v1/imagery/contracts/IImageryService/GetImageryMetadata, and are…


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 customer issue recently related to Client Printing of SSRS Reports. Scenario: Let’s say you want to disable Client Side Printing on Reporting Services when you open your reports through your application on Internet Explorer. You use Report…


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…