Adding New columns to the last file not reflecting in the Dataset

[Saran_T22]

Hello, @developer 

I'm brining my data (in parquet) from the AzureStorage Datalake back from 2021. Three new columns are added to the last file recently, say on 05/05/2022. When I try to refresh the Data set, the new columns doesn't show up. Can someone help me with this please? 

Thanks in advance. 

[v-yangliu-msft · Accepted solution]

Hi  @Saran_T22 ,

This is the related document, you can view this content:

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

https://community.powerbi.com/t5/Power-Query/adding-Column-to-Source-Data-but-doesnt-show-in-Refresh...

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

https://www.youtube.com/watch?v=kOw7JrIRVTY

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Saran_T22]

Thankyou so much @v-yangliu-msft . These links are so helpful. Really appriciate your response.

However, I had to try another option of removing the 6 steps generated when combining files in Power Query then on the Source step combine the files and choose one of the new files to be used as a sample file. the same sample file from when the query was originally built to know what columns to include. But still I will accept this as a solution as it did help figure something 🙂