Scenarios of Using Calculated Tables in Power BI

Calculated tables first introduced in September 2015 update of Power BI Desktop. The name speak for itself; these are tables created by calculation. As these are in-memory tables their calculation is based on DAX (Data Analysis eXpression language). There are many benefits of using Calculated tables, such as using them for role playing dimensions (for Read more about Scenarios of Using Calculated Tables in Power BI[…]

Webinar Materials Ready: Power BI Rises; Wonderful Things You Can Do

Thanks to all attendees to my webinar yesterday. It was pleasure to have you all attending in this session. I’ve uploaded session slides here and you can download them. Session was mostly demos rather than slides however. Unfortunately there was a technical issue and session didn’t recorded. I will get this recorded offline and upload Read more about Webinar Materials Ready: Power BI Rises; Wonderful Things You Can Do[…]

Power BI and Spark on Azure HDInsight; Step by Step Guide

Power BI can connect to many data sources as you know, and Spark on Azure HDInsight is one of them. In area of working with Big Data applications you would probably hear names such as Hadoop, HDInsight, Spark, Storm, Data Lake and many other names. Spark and Hadoop are both frameworks to work with big Read more about Power BI and Spark on Azure HDInsight; Step by Step Guide[…]

Be Fitbit BI Developer in Few Steps: Step 3 Visualization

In previous steps you’ve learned how to extract and mash up the data from CSV and automate the process of looping through all CSV files in the source folder. In this step we are going to build visualizations based on the data set we’ve built so far. In this post you will see how easy Read more about Be Fitbit BI Developer in Few Steps: Step 3 Visualization[…]

Be Fitbit BI Developer in Few Steps: First Step Get Data from CSV

Power BI made things really easy, it isn’t hard to build dashboards and data analysis on almost any types of data sources. Previously in other sections of the online book; Power BI from Rookie to Rockstar I’ve mentioned few data sources and ways of connecting to them. In this post I like to show you Read more about Be Fitbit BI Developer in Few Steps: First Step Get Data from CSV[…]

Power BI Says Hi to 3D Maps

If you’ve read my previous articles about Power BI, you know that Power BI has five main components: Power Query, Power Pivot, Power View, Power Q&A, and Power Map. So far all of these components were now supported in PowerBI.com website as part of your Power BI solution except Power Map! Power Map was the Read more about Power BI Says Hi to 3D Maps[…]

Live SSAS Multi-Dimensional Connection from Power BI

Power BI Desktop comes with new updates today as well, and the best feature in this update (from my point of view) is Live connection to SSAS Multi-Dimensional. This feature is still in preview mode, but it is good to see that Microsoft Power BI team invested on this most wanted request from users. With Read more about Live SSAS Multi-Dimensional Connection from Power BI[…]

How to Do Power BI Mapping With Latitude and Longitude Only

You may have seen many videos or blog posts so far that Power BI Desktop showed the data on the map visualization based on address, suburb, city, state, and country. Fortunately Bing Map helps a lot to search the point on the map based on address fields. However sometimes you don’t have address fields, actually Read more about How to Do Power BI Mapping With Latitude and Longitude Only[…]

Definitive Guide to Power BI Personal Gateway

If you’ve followed my Power BI from Rookie to Rockstar book so far, you know that Power BI can reach on-premises data sources as well as cloud based. With Power BI Desktop you simply connect to on-premises data stores, however when the report published into Power BI website there should be a bus connection between Read more about Definitive Guide to Power BI Personal Gateway[…]

Power BI Get Data: From Azure SQL Database

Power BI and Power Query can connect to files such as Excel, CSV, text files and on-premises databases such as SQL Server, Oracle, MySQL. Power BI can connect to many data sources on cloud such as Azure SQL Database, Azure SQL Data Warehouse and etc. In this part you will learn how to connect from Read more about Power BI Get Data: From Azure SQL Database[…]