Monitor Real-time Data with Power BI Dashboards

I’ve hear this a lot in my presentations that “Does Power BI support real-time data?”, And I answer yes. In fact this feature was available long time ago with Azure Stream Analytics and Power BI, however recently some new changes happened in this area which allows Power BI dashboards to monitor real-time data changes on Read more about Monitor Real-time Data with Power BI Dashboards[…]

Bring the Power into Your Application; Power BI Embedded

Power BI which released at July 2015 targeted business analysts and power users. From that time Power BI team made massive enhancements, and with each enhancement the user market of Power BI expanded. Recently Power BI take a big step forward with bringing developers as users. Power BI Embedded is the Power BI reporting solution Read more about Bring the Power into Your Application; Power BI Embedded[…]

Storytelling with Power BI Scatter Chart

Column or Bar chart can be easily used for showing a single measure’s insight across a category. Mixed charts such as Line and Column chart can be used for showing two measure and comparing their values across a set of categories. However there are some charts that can be used to show values of three Read more about Storytelling with Power BI Scatter Chart[…]

Dashboard Design for Mobile Power BI

In this blog post of Mobile friendly Power BI report development series I would explain how to design dashboards for mobile devices. Fortunately this has come right at the time of the recent update on Power BI service with ability to design dashboard page specifically for mobile device. The dashboard design for mobile does work Read more about Dashboard Design for Mobile Power BI[…]

Row Level Security with SSAS Tabular Live Connection in Power BI

You can define Row Level Security in Power BI itself, However sometimes you do use SQL Server Analysis Services Tabular as the source for Power BI through Live or DirectQuery connection. SSAS Tabular allows you to create same type of Row Level Security. So it would be much better to use Row Level Security defined Read more about Row Level Security with SSAS Tabular Live Connection in Power BI[…]

My Sessions at PASS Summit 2016

PASS Summit is without any doubts largest and biggest Microsoft SQL Server and Data Platform conference in the world. This happens in Seattle usually in October, and for 2016 it would be 25-28th of October 2016. This conference gathers almost 5-6K SQL Server and Data Professionals from around the world. As a speaker in Microsoft Read more about My Sessions at PASS Summit 2016[…]

Step by Step Walk through: On-Premises Live SQL Server Connection with Power BI Enterprise Gateway

I have mentioned previously that one of the ways to step beyond Power BI 10GB limitation is to use Power BI with Live Connection. In this post I will explain in a full step by step walk through how to use SQL Server as a DirectQuery or Live source for Power BI, and how to Read more about Step by Step Walk through: On-Premises Live SQL Server Connection with Power BI Enterprise Gateway[…]

Tips for Mobile Friendly Report Development with Power BI

Power BI supports mobile devices through Power BI app for Android, Windows Phone, and IOS. Dashboards of Power BI can be seen nicely in mobile devices. However there are some difficulties to get a mobile report up and running in a way that it be useful for mobile users. In this post I’ll share some Read more about Tips for Mobile Friendly Report Development with Power BI[…]

Make Your Numeric Division Faultless in Power Query

When you work with data it is normal that you apply numeric calculations. Numeric calculations in Power Query depends on the nature of data returns different results. One of the most error prone calculations is division. Power Query behave differently when you divide a number by zero, zero by zero, number by null, and non-numeric Read more about Make Your Numeric Division Faultless in Power Query[…]