Dataflow is a set of tables on The main benefit is that one person in company can handle the connection to datasources and cleaning of data (and thus create Dataflow) when other people can connect to it and create custom repots on it.

So how to create Dataflow?

In portal go to worksplace / Dataflows.

Create new Dataflow:

For demonstration, let´s use Web Api - some webpage with no authorization, no gateway etc:

in this example let´s use this exchange rate list:

In next step we appeared in an interesting environment, similar to Power BI Query editor. You can simply modify tables here.

It is obvious, that compared to Power BI Desktop, the abilities of this editor are very limited. Fortunately, you can use Advanced editor and there write in M language (or copy - paste here from Power BI Desktop Query editor)

After confirmation and closing you can Save it, Refresh (load data) or schedule autorefresh.

From now, you can in Power BI Desktop select this Dataflow as a datasource and use it as any other source.


  1. When will we be able to connect to dataflows from Power Query in Excel?

  2. I don´t know, but using “Analyze in Excel” is nearly as good…

  3. An operation nkn was performed to send the receipt - see the document says:

    An operation 5ti was performed to send the receipt – see the document

Leave a Reply

Your email address will not be published.


clear formPost comment