REFRESH FILES FROM FOLDER in Power BI | What to do when new columns don't show?

[Michael-BI21]

I have built a powerBI dashboard with data source from Datalake Gen2. I am trying to add new column into my original data source. How to refresh dynamically from PowerBI side  whats the best way to do?

[amitchandak · Accepted solution]

@Michael-BI21 , are you on the latest version of power bi. Because the newer one adds additional columns for few sources.

otherwise the manual process is, add again. Then copy the first few lines of code using the advance editor in power bi and replace them in the advance editor of old table

[v-luwang-msft · Accepted solution]

HI @Michael-BI21  ，

You can add the column in your new data source, when Power BI refreshes against the data set you will NOT see it in report designer. You will have to go into the Query editor, select the dataset & refresh the preview. It will then pick up the new column. It will now show in the report designer.

Go to Transform Data and select transform data option 

Look for "Transform Sample File" on left hand side and select it 

Select advanced editor on top center and you should see something like this. and simply increase the number of columns your sample file can possibly contain. 

To learn more details ,refer:

https://community.powerbi.com/t5/Desktop/New-column-in-source-table-not-appearing-in-dataset-after/m... 

https://stackoverflow.com/questions/60143531/refresh-powerbi-data-with-additional-column 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Michael-BI21]

@v-luwang-msft 

Thank You very much,also instead of increasing number of column to accept any number of additional column we can say ,  column = null .

[amitchandak · Accepted solution]

@Michael-BI21 , are you on the latest version of power bi. Because the newer one adds additional columns for few sources.

otherwise the manual process is, add again. Then copy the first few lines of code using the advance editor in power bi and replace them in the advance editor of old table