power bi gateway error

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...

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...

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...

Count Measure Issue in Tabular 2016 DAX Query

At BICG we are among the early adaptors of SQL 2016 and upgraded existing SQL 2014 server to SQL 2016. We went ahead and started moving away from DataZen and started creating Mobile Reports against exiting upgraded Tabular Models. Everything started to looks good until we hit few...

Find Text in SQL Views or Stored Procedures

Over the years this little piece of code has been useful when trying to search for text in SQL objects, this can help with finding dependant obeject in your code and can be used in build automation. SELECT DISTINCT a.[name] FROM sysobjects a INNER JOIN syscomments b on a.id =...

Time zones with SQL Server CLR and TimeZoneInfo

Download Code here I come across a little issue when migrating Appointment dates from a legacy system to Microsoft CRM Dynamics, we found that the date time that was being migrated was being adjusted based on the clients time zone, assuming that the time zone was GMT Standard...

Journey to Microsoft Certified Master: SQL Server 2008

By: Simon Liew MCM Journey to Microsoft Certified Master: SQL Server 2008 I attempted Microsoft Certified Master (MCM) exam in second half of 2012 and thankfully passed both Knowledge Exam (88-970) and the Lab Exam (88-971) in my first attempt. I’m categorised in the “new” MCM...
Send