Forum Discussion
Combine, load and transform options do not appear in Excel
Load, combine and transform options do not appear in my Excel 2016 when selecting a folder with several files, how do I choose these options?
Before these options appeared, on my machine, it was the only one in the area that appeared, I need to format it and it no longer appears...
When you click OK, after selecting the folder with the files, the Query Editor opens directly and the options do not appear, can anyone help me?
Desired screen:
Screen displayed:
2 Replies
Desired screen is for the connection to the selected file.
Screen displayed is when you select From Folder connector.
Please note as well, on 2016 is outdated version of Power Query, interface could be slightly different.
- Mariano_bomfim17Copper Contributor
SergeiBaklan, agradeço o retorno, no entanto, eu fiz esse procedimento com uma pasta com vários arquivos, e aparecia essa tela desejada. Eu já havia tentado configurar nas outras máquinas da área e apenas a minha aparecia essa tela desejada fazendo o mesmo processo, as outras máquinas estavam indo diretamente para a tela exibida.
Não sei se há alguma configuração ou extensão necessária, estou pesquisando ainda.