Configuring Power BI Report Server May Preview – Part 2

The May 2017 Preview of Power BI Report Server can be downloaded here. This post explains with guided video examples, how to configure Power BI Report Server May 2017 Preview edition.  This means the configuration part after installing.  If you missed the first part of this...

T-SQL syntax not acceptable in Azure SQL Data Warehouse

In your code Migration from SQL Server to Azure SQL DW, you will have to review some T-SQL syntax that are not acceptable in Azure SQL Data Warehouse. Here are the list of commands that will not work in your Azure SQL Data warehouse: ANSI joins on updates ANSI joins on deletes...

How to export Sharepoint Lists and import to SQL Server

At least once in your life as Business Intelligence developer, you will have to face the challenge to read some list that is stored inside Sharepoint. Looking back at the version 2010, it was pretty easy to select a table named “AllUserData” and then figuring out what...
Send