New column added to Dataflow not displaying in Dataset

Hi All,

As far as I know, in order to have a new table/column available in a dataset, an user must first import the dataflow from Power BI Desktop, then publish the report to the Service. I.e., Power BI Desktop is the mean to turn dataset schema update (I don't know if there are others means).

I'm experimenting a similar issue:

1) the IT staff added a column to an existing table of a dataflow already used by a published dashboard

2) I can see the new column in the dataflow query editor and run a refresh successfully but...

3) ...when I import the table in PBI Desktop, the new column is not available

I did some testes:

a) I created a new dataflow, add the table, saved, refreshed and imported in a PBI Desktop file. However, I don't want to use a brand new dataflow for each change of table/column, so...

b) ...so I edited the existing dataflow, added the table (which stays beside the existing old one), replaced the code of existing table with the new one. Kind ok work around, I'd like to have some more straightforward. But it works.

Thanks

Hi S4CSurrey ,

We want to check if the error is exist only on the old dataflow, If the same query works in Power BI Desktop, we think if using the same query in a new data flow entity, it will show the new column. Could you please check if this issue only exist in the spetific old dataflow?

Best regards,