Category: Self Service BI

Power BI Tutorial: How to Use Single Date Dimension in Your Model (using USERELATIONSHIP() Function)

Let’s take a look at an unfortunately very familiar to most of us business scenario. A patient gets admitted to a hospital, spends several days there and then gets discharged (hopefully feeling much better 🙂 ). In this situation, we have two dates that describe this event, the date of being admitted and the date

Continue reading

What is Power BI?

I find it interesting that after it’s been out for a long while, and after some great attempts by non-Microsoft sources to provide an adequate definition, I am still struggling with being able to provide a succinct explanation of what Power BI is to my customers. My best attempt thus far has boiled down to

Continue reading

Few thoughts on the SQL Server 2014 launch event in San Francisco

I just finished watching the hosted customer even in San Francisco where the Microsoft CEO Satya Nadella, COO Kevin Turner, CVP of Data Platform Group Quentin Clark and the SQL Server Product Marketing GM Eron Kelly officially introduced the new release of the SQL Server 2014. In this post I am not going to give

Continue reading

What is Power BI Gateway?

After I wrote the step by step guide on integrating on premise data with Power BI models I realized that I actually dispensed some bad advice. The basic premise of the post was to demonstrate how one may use Power Query to source data into a Power Pivot model in a very elegant way (at

Continue reading

HTML5 support In Power View and Power BI

Now that Power BI is Generally Available (GA) I thought it would be useful to do a quick analysis of how Power View visualizations are supported in Power BI across the three media – Silverlight (default), HTML5 and Windows 8 App Please find a table below for a quick reference Feature Silverlight HTML5 Windows 8

Continue reading