Profile cover photo
Profile photo
Gerhard Brueckl
3 followers
3 followers
About
Gerhard's posts

Post has shared content
Using Self-Signed Certificates for your Power BI DMG running on an Azure VM #powerbi #azure

In my previous post I showed how to setup a Power BI Data Management Gateway on a non-domain Azure VM. The final setup is also the starting-point for this post where we will use self-signed certificates to use HTTPS/SSL connectivity to our DMG. So make…

Post has shared content
Performance isse with SSAS Dynamic Named Sets used in Calculated Members #SSAS #MDX #DynamicSets

Recently at one of my customers we were doing some performance tuning on a SSAS Multidimensional cube and I came across something I have not seen before yet in my lifetime as a SSAS developer. Even the simplest select queries where running for several…

Post has shared content
Recently I had to setup an Analysis Services cube and expose it to external users. This is usually done by using Internet Information Server (IIS) and creating a new WebSite which hosts msmdpump.dll. This DLL more or less wraps XMLA commands inside HTTP…

Post has shared content
Happy New Year! – How about some Conferences? #SQLPass #SQLBits #sqlpass_de #SQLKonferenz #SQLSaturday #SQLSatVienna

2015 just started – and it is a quickstart in terms of SQL Server conferences! There is quite a lot of upcoming conferences and I am happy that most of them are in Europe. Below you can find a short overview followed by some more details: What? When?…

Post has shared content
Recursive Calculations in #PowerPivot using #DAX

If you have ever tried to implement a recursive calculations in DAX similar to how you would have done it back in the good old days of MDX (see here) you would probably have come up with a DAX formula similar to the one below: Sales ForeCast := IF (…

Post has shared content
Dynamic ABC Analysis in Power Pivot using DAX – Part 2 #dax #powerpivot

Almost two years ago I published the first version of an Dynamic ABC Analysis in Power Pivot and by now it is the post with the most comments among all my blog posts. This has two reason:1) the formula was quite complex and not easy to understand or…

Post has shared content
I am speaking again! Upcoming Events in June 2015 #sqlpass #sqlsaturday #sqlpass_de #SQLSatRheinland

I am very glad that I got selected as a speaker for two upcoming SQL Saturdays in June. First there is the SQL Saturday #409 in Rheinland, Germany  on June 13 and the week after the SQL Saturday #419 in Bratislava, Slovakia on June 20. For those of you…
Wait while more posts are being loaded