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[…]
Azure Data Factory has been released as general availability 10 days ago. There has been also an extension for Visual Studio published a little earlier for Data Factory. The good news is that now you can create Azure Data Factory projects from Visual Studio. This is a great step forward in development of Data Factory Read more about Azure Data Factory Templates for Visual Studio[…]
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[…]
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[…]
On Late May when CTP 2.0 of SQL Server 2016 published, I’ve wrote a blog post about What’s New in MDS 2016. Recently CTP 2.2 has been published, and I’ve seen some new features again added to MDS. In this post I’ll explain new features of MDS 2016 CTP 2.2 which are;
Fetching list of Files in a folder is easy with Power Query, it is one of the built-in source types. However fetching list of folders is not a built-in function. In this post I’ll show you how to fetch list of files, and also fetch only list of folders. The method explained in a way that you can customize the code and apply any conditions as you want later on. Conditions such as File or folder name masking to fetch only names that contains special character strings.
With the announcement of Power BI a week ago and with great features in this product, there are many opportunities that this product and service can be used. Power BI can be used alongside some other Azure services, and even On-Premises services to build an end-to-end enterprise BI and Data Analysis Solution. In this post I’ll just explain one example scenario of Hybrid and End-to-End BI solution that uses below technologies;