Change source from SQL Server database to Dataflow

[PBI_hlpr1]

Hi all,

in PBI desktop I have a quite complex query called Fact_Sales getting and transforming data from an SQL Server table called f_NSV.  We have now setup and configured a gateway so I have setup a dataflow that is automatically refrescing data overnight from the SQL table f_NSV. How can I change Fact_Sales in PBI desktop in order is pointing to the dataflow and not directrly to the SQL Server?

Thanks to anyone who could help.

C.

[v-jianboli-msft · Accepted solution]

Hi @PBI_hlpr1 ,

You can connect to the dataflow and then replace your original table with the new table.(Delete your original table and use Fact_Sales rename the table from dataflow)

A dataflow can be consumed in the following three ways:

• Create a linked table from the dataflow to allow another dataflow author to use the data.

• Create a dataset from the dataflow to allow a user to utilize the data to create reports.

• Create a connection from external tools that can read from the CDM (Common Data Model) format.

Consume from Power BI Desktop To consume a dataflow, open Power BI Desktop and select Power BI dataflows in the Get Data dropdown.

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PBI_hlpr1]

Perfect @v-jianboli-msft , thanks so much.

Regards,

C.