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 merge statement cross-database […]
Read MoreArticles by: Luis Bastos
Boosting your financial reports with Power BI
Power BI Gateway: There are currently no logon servers available to service the logon request
Perhaps you have faced this error: “There are currently no logon servers available to service the logon request” while connecting to SSAS (Analysis Services) for the first time in Power BI via Gateway. In this post I will show you two possible solutions: Active Directory Installation For Windows 10 or 8, […]
Read More
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 is the right […]
Read More How to connect to Azure DW via SQL Server Management Studio (SSMS)
Azure DW has been become more and more popular, and there is no doubt that Microsoft is putting all its efforts on the cloud. For those who wants to begin with this trend in Business Intelligence , simple questions can pop up our minds. This article will explain how to setup a simple data base in […]
Read More
Overview of SQL Server 2016 features for Business Intelligence
No doubts that SQL Server 2016 is the hugest leap forward in Microsoft Business Intelligence platform history with features that increase performance, simplify management, and transform your data into actionable insights. Moreover, you have powerful reports and dashboards on the palm of your hand. With a variety of new features […]
Read More