New columns added on dataflow won't appear in dataset

[retailbusiness]

Whenever I create a new column on a dataflow, I have to open the dataset on Desktop PBI and refresh from the table "refresh data" option to display the new column. Online (PBI service) dataset refresh won't update table schema only Desktop PBI will! I don't know if it's normal behavior.

[v-xiaotang · Accepted solution]

Hi @retailbusiness 

Thanks for your sharing.

Currently, columns imported into a dataset are decided in Power Query Editor(With it, you could add/remove columns or enable/disable load of tables). For dataflow, you could add a column by Edit it in Power BI service. But for dataset, product group doesn’t provide an option to open Power Query online for it. So if you would like to add a column to a dataset, you need do it in Power BI Desktop.

For the need of this feature, you may vote and add comments with more details for similar idea in Power BI Ideas. It’s a place where the product group collects needs and suggestions from users and they will take them into considerations when designing or improving this product. Link of the idea: https://ideas.powerbi.com/ideas/idea/?ideaid=887f5c80-cfa9-44b5-b797-c1434fbd622e . Thanks in advance!

Best Regards,

Community Support Team _Tang

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