Day Number of Year, Power Query Custom Function

Posted by on Jul 28, 2015 in Power BI, Power Query | 3 Comments

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 ...

Read More

Introduction to Power BI Designer

Posted by on May 15, 2015 in Power BI | No Comments

Power BI Designer is the new Editor for Power BI main components which are: Power Query, Power Pivot, and Power View. Power BI Designer made building Power BI solutions easier with an integrated solution. Power BI Designer’s files can be easily uploaded into Power BI site. In this tutorial video you will learn basics of ...

Read More

Presentation Materials: TechDays Hong Kong 2014, Advanced Data Transformation with Power Query

Posted by on Mar 26, 2014 in Power BI, Power Query, Presentations | No Comments

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

Scheduling Power Query ETL Runs

Posted by on Feb 16, 2014 in Power BI, Power Query | No Comments

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