Forum Discussion

Qmars007's avatar
Qmars007
Frequent Visitor
4 years ago

Adding new columns on a table in dataflow from Power Bi Desktop

Hello, I'd like to know if I can add a calculated column to a table in Dataflow, using Power BI Desktop? The process is as below: 1- Opened Power Bi desktop 2- "Get data" 3- Select "Power BI dat...
Dataflow
JamesDBartlett3's avatar
JamesDBartlett3
Advocate II
3 years ago

As of this writing, Power BI Dataflows can only be edited in the Power BI service (i.e. in your web browser of choice).

 

When you connect to a Power BI Dataflow from Power BI Desktop, you are specifying that Dataflow as the source of data for your current report/dataset. Any changes you make in the Transform Data (Power Query) window of Power BI Desktop are applied as additional steps after the data has already been imported from the Dataflow, so those changes will only apply to the report/dataset you're currently working on, and will not show up in the Dataflow.

 

If you need to add a new column to a Power BI Dataflow, you'll need to edit it directly in the Power BI service, using the same interface you used when you created it.