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.
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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I want  to add a new column to power bi from a data Cube without changing anything in the data cube.Is it possible to add new column to power Bi without modifiying in Data Cube.

 

Please let me know...