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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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