Forum Discussion
Helper INew Column in PBI Dataflow not displaying in Dataset
Hi vckbx ,
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 _ Caiyun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!
Community SupportHi vckbx ,
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 _ Caiyun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!
I am having the same issue.
I added a new column in my excel file. I updated the dataflow that is linked to the excel file. I refreshed the dataflow. I refreshed my dataset. I can see the new column on the web in my dataflow, but it does not load in my dataset.
I don't understand the accepted solution. I am linking to the dataflow without any edits in query editor so it should all flow through.