Forum Discussion
Why Dataflow does not load new columns from SQL
I have a dataflow querying a SQL table, such as
seelct * from [dbo].[tbl]
IF the dataflow is created today and a column called [colA] gets added to SQL table tomorrow ([colB...
v-janeyg-msft thanks for testing it out. Is there any chance for the default behavior to inlude newly added colums in the near future without manual intervention required?
Hi, smpa01
This is not easy to say. Refresh in pbi desktop and pbi service is different, in service only existing columns are refreshed. If you delete a column and then refresh, you will find that it will report an error. You can only save the latest columns after reloading in the editor.
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Community Support Team _ Janey