Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Add an extra field from a data source

A power bi newbie here.  Say if I import a table A from a data source into power bi, some minor changes to the imported dataset. calculated columns, measures etc. Now I add a new field in the table...
Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago
    Anonymous

    If I didn't misunderstood you, when you refresh in power bi desktop your new added column will automatically be imported.
SabineOussi's avatar
SabineOussi
Skilled Sharer
10 years ago

Make sure you have saved your spreadsheet before refreshing in Power BI.

  • carinat's avatar
    carinat
    Advocate II
    10 years ago

    Refreshing columns that are already there is no problem. Getting the new columns included is though.

    • frandsb's avatar
      frandsb
      Advocate I
      10 years ago

      I had the same issue.  My source is a URL that returns a CSV.  When the owner of the URL (a vendor) adds a new column to the CSV, PowerBI does NOT detect the new column.

       

      I have gone into Edit queries -> Refresh Preview.

       

      I can copy / paste the URL from the "Source" of the query into a browser and the CSV that returns has the new column.

       

      However, looking in PowerBI...even clicking on the "Source" in the "Applied Steps" so that NOTHING has been done with the source data - no columns hidden, etc - the new column is NOT there.

       

      If I change the URL to nonsense, save, then re-paste the URL into the source it will then find the new columns.  A clumsy forced refresh.  Should be a better way.

      • elsalvador182's avatar
        elsalvador182
        Advocate IV
        10 years ago

        I have this issue also and it is very frustrating. We add addional columns and fields to source csvs all the time.

         

        I have a work around that used to work...until today.

         

        This way you will not lose any of your steps, which is very important especially if you have a complicated report that could break.

         

        The work around is this:

         

        1) refresh everything, make sure the new column is in the source csv

        2) under applied steps in query editor, go to source and hit the settings gear icon to right of "source"

        3) Choose Open file as "Automatic" hit OK

        4) Your table will dissappear, double click the csv file icon, hit "insert" when the insert step box pops up

        5) Your newly added column will appear at step 1 "source"

        6) to make sure it stays , under "choose columns" or if you have a "removed columns" ...make sure the check box for that new column is checked

        7) Your column is good to go now

         

        This usually works. Except today it started giving me a wierd error after applying query edits Which is why I am here searching.

         

        EDIT* I fixed my error. I was being dumb. My work around works again.