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,

     

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi S4CSurrey ,

 

Could you please check if you can see the new column in a blank report based on the dataset? What is the data type of this new column , based on this document: A dataflow must output one of the following types: Date/Time, Decimal Number, Text, Whole number, Date/Time/Zone, True/False, Date, Time

 


Best regards,

 

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

    I tried in a new report, not there still.

     

    In Power Query, it is currently a Text type column. The source data is just a String type from my online database. Other string type fields are coming in and set to be a Text type column, and are working.

     

    As a test, I set the column type to be Decimal, and the column's data still displayed properly. Switched back to Text, refreshed the data, and the column's data still displayed properly. Refreshed the Dataflow and Dataset, re-checked the new test report and analyzed it in Excel, and the column of data is still not accessible.

    • v-lid-msft's avatar
      v-lid-msft
      Icon for Community Support rankCommunity Support
      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,

       

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

        I just tried with Power BI Desktop, and it does show up there! I was able to re-publish the report and it has updated the dataset as well.

         

        Why is this required? Can't it all be edited online?