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[…]
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[…]
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 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[…]
In Previous section you learned about Power Query through an example of data mash-up of movies. Also prior than that you’ve learned about Power BI and its components in Power BI online book from rookie to rockstar. In this section I would like to start exploration of different data sources in Power BI, and I Read more about Power BI Get Data From Excel: Everything You Need to Know[…]
As another section of the Power BI online book: from Rookie to Rockstar, I would like to get start working with Power Query. From my point of view learning through an example is the best way to learn new technology. For this post I have decided to use movie’s data to be mashed up. I Read more about Get Started with Power Query: Movies Data Mash-Up[…]
In this post you will find materials for the Power BI Mission Possible! session that I speak today in PASS BA Virtual Chapter. Thanks to all attendees of my session in PASS Business Analytics Virtual Chapter today. Unfortunately I hadn’t chance to respond all questions, So here in this blog post I write answers to Read more about Power BI Mission Possible; Webinar Q&A, Recording, and Materials[…]
Almost one month ago Power BI has been released for general availability with shiny new features, and I’ve wrote a blog post about new features in Power BI 2.0 General Availability. at 20th of August Microsoft released an August 2015 update version of Power BI Desktop with some new features. In this post I’ll go Read more about What’s New In Power BI August 2015 Update[…]
When you get data in Power BI you actually use Power Query Component. In this chapter you will learn about What Power Query is, and what are different types of sources that Power Query can connect. Power Query has also great list of transformations that can be applied on the data set as well (which Read more about What Is Power Query? Introduction to Data Mash-up Engine of Power BI[…]
In previous section (from the Power BI from Rookie to Rockstar book) you’ve learned about Power BI Desktop, and you’ve developed a sample report with that and published it to Power BI website. In this section I’ll explain some of Power BI website’s functionality. You will understand at the end of this section that Power Read more about Power BI Website: You’ll Need Just A Web Browser[…]