Forum Discussion

S4CSurrey's avatar
S4CSurrey
Icon for Helper I rankHelper I
6 years ago
Solved

New column added to Dataflow not displaying in Dataset

I have a pre-existing Dataflow that is calling data over REST. I have a Dataset created for this Dataflow, and a connected Report displaying data correctly.   Today, I edited the query in the Dataf...
Dataflow
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi S4CSurrey ,

     

    Could you please check if you can see the new column when using the same query in Power BI Desktop?


    Best regards,

     

denpries's avatar
denpries
Icon for Resolver I rankResolver I
3 years ago

I have an exact similar issue to the one you describe.

I have added in a dataflow 3 new columns.

Aother, existing dataflow, combines this dataflow with another flow.

 

In the flow editor on the service you see the three new columns as last step. When refreshing, all goes well.

PBI desktop however cant see the new 3 columns, also not when you clear cache.

 

The only resolution is to e.g. add a useless replace operation in the query of the flow on an arbitrary column, not per se the 3 missing ones, 'e.g. replace X with identical X' . After refreshing the new columns also appear in powerbi desktop.

Strangely enough, when removing the useless replace again, the columns also stay.

 

What i think, is that something in the underlying scheme is not updated, until you force it to. (or something like that)