Jan Pieter Posthuma

Introducing AzureBI Documentation

As of today the https://azurebi-docs.jppp.org site is official available. This website is the result of my decision I made a couple of weeks ago: to open source all my community project documentation.

Visualizations

VSCode extension for Power BI Custom Visuals

Visual Studio Code Extension This Visual Studio Code extension adds the option to directly start and restart the PowerBI Visual tools (pbiviz) for developing Power BI Custom Visuals. Features Add

Visualizations

Power BI visuals delivered via Azure CDN

Introduction Power BI has the ability to import custom visuals and use them in your reports and dashboards. This is a great option to extent the visual capabilities of Power BI without waiting before Microsoft is adding that visual capability. Even Microsoft has created

Azure

Managing Azure credits with Power BI

Recently I ran out of Azure credits before the new billing month was started. The result: Azure automatically disables the account and none of my resources were available. Next question

Reporting

Using Let’s Encrypt certificates for secure SQL Server connections

Let's Encrypt Since December last year, the Let’s Encrypt initiative has gone into public beta. Let’s Encrypt is a free, automated, and open certificate authority, so you can easily get free official SSL certificates. Primarily it is focused on securing the web,

IoT

Pushing data thru Azure Stream Analytics to Power BI - part 4

After 6 months there has been a lot of changes in the offering of Azure and Power BI. Those changes implies that my blogposts about connection Stream Analytics and Power BI (1, 2 and 3) are not completely the best and easiest way of

Analysis

Unraveling the Microsoft Analysis Services Deployment Wizard

Analysis Services Deployment Wizard Admit: either you love it or you hate it. And I must confess I was part of the last group, but now the wizard have convinced me to love it despite some caveats. So what did me switch sides? First

Power BI

Pushing data thru Azure Stream Analytics to Power BI - part 3

Note: see this article for some new insights. After the first two parts (1, 2) now it is time to look at the code to push data to the event hub and process the data from the event hub and push it to the

Power BI

Pushing data thru Azure Stream Analytics to Power BI - part 2

Note: see this article for some new insights. In part 1 I provided an overview of the given solution. And now it is time to configure Azure Service Bus, Event Hubs and Stream Analytics to be able to sent and receive messages. I still

Power BI

Pushing data thru Azure Stream Analytics to Power BI - part 1

Note: see this article for some new insights. Since the beginning of this year a new version of Power BI has been release in preview and since half March this version is available worldwide. One new feature of this preview is that there is

DAX

Multiple hierarchies and xTDs

Last week I was challenged by a co-worker: *‘create a way that a tabular cube case serve a YTD value for different time hierarchies.’ *Because I work at a retailer at this moment, there is a fiscal calendar and a 454 calendar, which of

Power View

Adding #Trendlines to #PowerPivot for #PowerView

Adding trendlines to PowerPivot It started during a presentation of Cathy Dumas at the latest SQLBits where she compared the different charting capabilities of Excel, Power View, PerformancePoint and Reporting Service. One of those capabilities were trendlines who are missing in V1 of Power

Analysis

The beauty of the #SSAS DefaultMember

The DefaultMember property for the dimension is know by every Microsoft BI professional. This property sets the default selected member of a dimension attribute, so that member will be selected by default. The dimension DefaultMember can be declared in BIDS or by using an

Analysis

My PerformancePoint experiences

Finally I made some time to write about my experiences with PerformancePoint 2010 and then focused on my dashboard specially for the iPad and the new SP1 features. Last April the was a business request to enable the existing PerformancePoint dashboard for viewing on

Analysis

Update on the future of SSAS

Last November I wrote about the future of SSAS and BISM (see here for the original post). Now with the release of CTP3 of SQL Server codenamed ‘Denali’ (download here), the new BISM and the two different modes are open to the public so

Analysis

Preparing for the #SSASMaestros in HK

After a long wait and a lot of arrangements, I am finally about to leave to Hong Kong for the SSASMaestro training. At this moment I got not that much to tell, mainly because of the NDA. But the slides already shared looks very

Analysis

Analysis on tagged customers

It is been a while since my last blog and of course I got the standard excuses. The two main are: busy with my project/customer and I intended to blog about the upcoming SQL Azure Reporting release, but as you know: it is

Analysis

My thoughts on the future of SSAS and BISM (UDM 2.0)

Today there is a lot of talking about the new BI Sematic Model (BISM) released with the next version of SQL Server, codenamed Denali. Chris Webb has written a good blogpost about the upcoming changes and gave his fair opinion to it. In most

Analysis

What about the future of BI

There is a shift going it the IT world: more and more applications are moving to the cloud. Recent examples, e.g. Office365, shows that the gap between the on-premise version and the cloud version are rapidly closing. Even the promise of Microsoft to