Month: January 2019

First published on MSDN on Apr 05, 2018

Writer: Simon Su

Technical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas Shah

Applies to: SQL Server 2014 SP2, SQL Server 2016 SP1, SQL Server 2017 RTM

In synchronous-… Continue reading Troubleshooting data movement latency between synchronous-commit AlwaysOn Availability Groups→

First published on MSDN on Mar 26, 2018

Dear all,

Depending on which products were installed on the server beforehand, a SQL Server 2017 setup may fail with the following error :

TITLE: Microsoft SQL Server 2017 Setup

… Continue reading Installation of SQL Server 2017 failing with ‘VS Shell installation has failed with exit code 1638’→

First published on MSDN on Mar 26, 2018

In general, there are several links available to download the ODAC components from the Oracle official site.  It varies across the Oracle versions, and the type of installer that we would ne… Continue reading Configure Oracle data source for SQL Server Reporting Services (SSDT and Report Server)→

First published on MSDN on Feb 26, 2018

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 particula… Continue reading You cannot publish more than 200 Dataset/Report together within an Workspace in Power BI service→

First published on MSDN on Feb 26, 2018

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 Offi… Continue reading “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→

First published on MSDN on Feb 26, 2018

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.

… Continue reading Using Amazon RedShift with Power BI→

First published on MSDN on Feb 16, 2018

This post is intended to shed some light around uniqueifiers and table design that rely on its usage.

First a quick information about the subject.

A uniqueifier (or uniquifier as … Continue reading Uniqueifier considerations and error 666→

First published on MSDN on Feb 06, 2018

Workloads that rely on auto-commit (each operation like an INSERT has an implied, corresponding begin and commit transaction) and perform a large number of small transactions may take signifi… Continue reading Analyze Synchronous Commit Impact on High Commit Rate Workloads→