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[…]
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[…]
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.
Joining tables is not a new concept, I bet all readers of my blog at least have a clue about that. However there are different types of joins, and applying these types of Joins are not all possible through Power Query GUI. Power BI recently took an step and implemented that in the GUI, however you might like to know how to apply that in the Power Query. The trick is that M is your friend, You can do whatever you want behind the scenes with M script.
Yesterday in NZ BI user group meeting, I’ve been asked that does Power Query custom functions return only one value as the result set? or they can return multiple values. I’ve answered Yes, and I’ve explained that through a sentence how to do it with Records, List, or Table. Then I thought this might be a question of many people out there. So I’ve wrote this blog post to illustrate how to return multiple values from a custom function in Power Query.
There are number of Date and DateTime built-in functions in Power Query which are really helpful. There is also a function for DayNumberOfYear. However I’ve thought it would be a good example to go through writing a function that uses Generators, Each singleton function, and error handling all inside a custom function. Through this post you will also learn;
Thanks you all attendees of my PASS Summit 2014 session on Power Query. It was a pleasure to have all of you in my session. I also appreciate Alberto, Chris, Devin, Donabel, and Rafael who dedicated some of their times to attend in my session. I hope this be an informative session for all of Read more about PASS Summit 2014: Speaking about Top 5 Functionalities of Power Query that You Don’t Know[…]
It is my pleasure that I’m selected to speak in upcoming SQL PASS Summit 2014. Thanks to program committee who give me this opportunity again. This is my second year in PASS Summit. Thanks to all attendees of my last year’s presentation. My presentation this year is: Deeper Data Insight and Prediction with Data Read more about Speaking at SQL PASS Summit 2014: Seattle[…]
Thanks to all attendees of my session in TechDays 2014 Hong Kong about Advanced Data Transformations with Power Query. Here is session Title, Description, and presentation file; Title: Advanced Data Transformations with Power Query Description: Power Query is the self-service data consolidation tool of the Power BI embedded in Excel. Power Query has ability to Read more about Presentation Materials: TechDays Hong Kong 2014, Advanced Data Transformation with Power Query[…]
In previous posts I’ve mentioned that Power Query is a self-service ETL tool. One of the most fundamental functions of an ETL tool is ability to schedule ETL run. In the other words you would require to populate data from operational data stores on a schedule basis to feed into your Data Model. Power Query Read more about Scheduling Power Query ETL Runs[…]