Tag: Power Query

Power Query Function that Returns Multiple Values

Posted on by Reza Rad

5

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.

[…]

Day Number of Year, Power Query Custom Function

Posted on by Reza Rad

0

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;

  • how to create Custom Function
  • how to use Generators as loop structure
  • and how to user Error Handling.

[…]

Self Service BI- Power Query-Section 1: Search for Data

Posted on by Leila Etaati

In this Video I tried to gather some information about Dog Breeds from different 3 websites : http://www.mans-best-friend.org.uk/dog-breeds-alphabetical-list.htm http://www.dogbreedslist.info/ https://en.wikipedia.org/wiki/List_of_dog_breeds I have explained how to get data from these websites even they don’t provide any API.    

Introduction to Power BI Designer

Posted on by Reza Rad

blog

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 Power BI Designer, some demos of this product, getting data from FIFA 2014 World Cup website, and creating charts and dashboards. In the demo you will also learn how to deploy the report to Power BI site, and how to view the dashboard and report from Power BI app.

[…]

Walk-through Steps: I’m New to BI, Where to Start? – Part 5: Power BI

Posted on by Reza Rad

pbi

Power BI is not a strange word these days, there are many blog posts, videos, news, and speakings about it. Power BI is Microsoft Cloud BI services that released recently. Power BI is not only Cloud BI but also it offers good self-service BI stack as well. Power BI has five main components which are:

  • Power Query: For data extraction, transformation, and load into model.
  • Power Pivot: Data Modelling tool.
  • Power View: Data Visualization tool
  • Power Map: 3D Geo-spatial data visualization tool.
  • Power Q&A: Engine for natural language questions and answering

[…]

SQL Saturday Vienna 2015- A Journey to Power BI

Posted on by Leila Etaati

To download the Session slides click below link : A-Journey To Power BI My session   God turn out in SQL Saturday Vienna   An Interesting Keynote speech by Mark Souza    Have fun the day after SQL Saturday around Vienna with other Speakers     I have Talked about Power BI in SQL Saturday Vienna , Special Read more about SQL Saturday Vienna 2015- A Journey to Power BI[…]

Power BI Pre-Con; from Rookie to Rockstar

Posted on by Reza Rad

Have you heard about Power BI? Do you know Power BI Components? Have you worked with Power Query Formula language called M? Do you know what are strong capabilities of this language and tool? Have you build PowerPivot models with strong DAX expressions and deployed in Power BI site? Do you know different types of Read more about Power BI Pre-Con; from Rookie to Rockstar[…]

PASS Summit 2014: Speaking about Top 5 Functionalities of Power Query that You Don’t Know

Posted on by Reza Rad

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[…]

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

Posted on by Reza Rad

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[…]

Scheduling Power Query ETL Runs

Posted on by Reza Rad

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[…]