PROBLEM: 3 new columns had been added to my DATASOURCE tables and I can't see these new columns when refresh my data sources via Power Query. I have imported multiple Excel files from a folder, so went back to check the steps.
When I get to expand 'Tables'. I have a 'GetExcelData.Hidden' column. Is this the reason why I am not seeing my 3 new columns?
<thead>
</thead><tbody>
[TD]DATASOURCE
[/TD]
[TD]Sheet
[/TD]
[TD]FALSE
[/TD]
</tbody>
When I get to expand 'Tables'. I have a 'GetExcelData.Hidden' column. Is this the reason why I am not seeing my 3 new columns?
GetExcelData.Name | GetExcelData.Data | GetExcelData.Item | GetExcelData.Kind | GetExcelData.Hidden |
---|---|---|---|---|
DATASOURCE |
<thead>
</thead><tbody>
[TD]DATASOURCE
[/TD]
[TD]Sheet
[/TD]
[TD]FALSE
[/TD]
</tbody>