Project Botticelli

Transforming Data with the Query Editor (2018 Updates) Purchase this course

21 December 2018 · 113 views

Power BI Course

Transforming Data with the Query Editor (2018 Updates)

This video covers new features in Power BI that are relevant to the Transforming Data with the Query Editor section of the course.

The From Web connector has always been able to scrape data from tables in web pages; it can now find repeating patterns of values in a web page and interpret them as a table based on example data you provide. Similarly, the Column From Examples transformation allows you to specify one or more source columns in a table and some examples of the output you would like to get, and the Power Query engine works out what transformation is needed to get from the input to your output.

Finally, custom connectors allow you to extend Power Query by building your own connectors to data sources, such as web services or databases, that are not directly supported by Power BI.

Log in or purchase access below to the premium version of this content.

Purchase This Course or Full Access Subscription

Single Course

$250/once

Access this course for its lifetime*.
Purchase
Subscription Best Value

$480/year

Access all content on this site for 1 year.
Purchase
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase

  • Redeem a prepaid code
  • Payment is instant and you will receive a tax invoice straight away.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.

* We guarantee each course to be available for at least 2 years from today, unless marked above with a date as a Course Retiring.

Online Courses