Adding new columns on a table in dataflow from Pow...

Qmars007 · ‎05-19-2022

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 dataflow"
4- Select the table I want to add a calculated column to it
5- I add that column.
6- Publish the table with the added column, using the "Publish to Power BI" option.
7- Replace the existing table on the "DataFlow" folder using the "Select a destination" option.
8- Open the modified table from the Power BI service.
9- Failure. On the modified table, I don't see the calculated column

What should I do? In essence, I was wondering if I can modify a table in Dataflow, using Power BI Desktop as I carry out the majority of my data modelling in Power BI Desktop.
Thanks in advance for any advice.

Best,

Q

JBartlett_DMU · ‎05-04-2023

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.