Query Groups

Query Groups is a new concept introduced in this update that will help users better organize their queries within a given workbook, as well as perform bulk operations on all queries within a group (such as Refresh). Up until now, Power Query offered only a few capabilities in order to organize queries in the Workbook Queries pane, primarily moving queries up and down in the list.

With this update, users can now select multiple queries using (CTRL + Click) and move them into their custom groups

Combine files from a folder. 

Use Power Query to combine multiple files with the same schema stored in a single folder into one table. 

Fill Down Blank or Null Cells in Power Query

Power Query (aka Get & Transform) has a Fill function that allows us to fill cells with the value above or below. This helps when your data contains cells or rows with blank (null) values, and you want to copy down the value from the cell above.

Publish to web from Power BI

• You need a Microsoft Power BI Pro or Premium Per User license to publish to web from workspaces.

• It isn't available for reports shared with you, or ones relying on row-level security to secure data.

• Not supported

  • Reports containing report-level DAX measures.

  • Single sign-on data query models, including composite models on Power BI semantic models or Azure Analysis Services.

  • Secure confidential or proprietary information.

  • Reports using row-level security.

  • Reports connecting to data using DirectQuery / Reports using any Live Connection data source,