combine from folder with new columns and connected to SharePoint

[enath]

Hello Power BI ,

I made a report where I use the strick to detect and load automatically a new column to the report like in this video :.

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

with this:

#"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File"}),
Data = #"Removed Other Columns1"[Transform File],
Headers = List.Distinct(List.Combine(List.Transform(Data, Table.ColumnNames))),
#"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File", Headers),

Everything is working well but when I want to connect this report to the SharePoint those step are not working anymore...and the quierry is failling : 

there is noway to add automatically new columns when combining files that located in sharepoint?

Thanks a lot for your help!!

Enath

[enath]

Thanks! 

do you have any idea to expand json automatically also when there are new columns? like she explained in the video you sent but in json?

[amitchandak · Accepted solution]

@enath , Curbal has suggested an approach in 2 videos, refer to it, if that can help. I have not checked the one you are using. so not sure if two are different.

https://www.youtube.com/watch?v=UY3hIV-THcg

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