Power Query (4/4): Extending Power Query

The last Power Query topic that is worth covering is extending the work to the cloud. We can do these one of two ways:

Publish PowerBI Report

The most popular way to extend Power Query code into the cloud is by publishing a PowerBI report which pushes both the dataset (along with its corresponding Power Query M code) and the report into the Power BI Service. We can then simply set up the connections and schedule a refresh and we are good to go.

Scheduling a Power BI Dataset Refresh (which executes our M code built in Power Query)

Power Query Online aka PowerBI Dataflow

The less common approach is by using Data Flows (aka Power Query Online) in PowerBI Service. Keep in mind that this is a premium feature and can only be built using the PowerBI Service in the cloud (not in the desktop tool). It works the same way – you can connect to a datasource and build your Power Query steps or paste in the necessary M code. Using dataflow has it’s own benefits but that’s a topic for another day.

Premium Workspace Feature – Dataflow (aka Power Query Online)
Power Query Online

The simplicity and extendibility of Power Query makes it an easy choice for creating automation around reporting and keeping data up to date. This paired with PowerBI’s modeling and visualizations make it a great one-two punch for reporting and allow the tool to satisfy the needs of all three pillars of data.

A Daily Email From Me

Give me a couple minutes of your day and I promise to provide thought-provoking messages to help you level up your BI knowledge and run more successful data projects.

A Daily Email From Me

Subscribe to get daily tips/ideas for how to best run a data project.

    We won't send you spam. Unsubscribe at any time.