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[…]
As promised I started writing blog post series for the Online Book: Power BI from Rookie to Rockstar, and this is the first post. Power BI is not a new name in the BI market, components of Power BI has been in the market through different time periods. Some components such As Power BI Desktop Read more about Introduction to Power BI: What is Power BI?[…]
The idea of writing a book on Power BI is not new for me, I’ve been thinking about it for a while, even before the first release of Power BI Designer. However, Power BI is fast-paced technology, Microsoft Product team is doing a great job with monthly, and sometimes even more frequent updates. With this Read more about Online Book: Power BI From Rookie to Rockstar[…]