Forum Discussion
Detecting sources files with missing fields
Looking for some help from the experts I have a power query that pulls files on Sharepoint. It will pull out a particular table on them The tables are supposed to be the same but not always are. ...
= List.ContainsAll( Table.ColumnNames( xxxtable ), {"colA","colB","colC"} )test if column names of a table contain all of {"colA","colB","colC"}
Thanks bu that is not addressing my question. The problem is when you combine source files and a sample file is used as a sample (example https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-combine-binaries)
In that case all files are read using the sample file structure with the results I described on the OP