Forum

Power Query - canno...
 
Notifications
Clear all

Power Query - cannot access individual files for editing before merging them

2 Posts
2 Users
0 Reactions
69 Views
(@Anonymous)
Posts: 0
New Member Guest
 

Hello,

I have for files that need to merge but before editing needs to be done. I followed the steps, loaded files from a folder, clicked on "Transform Data", however, when I choose the file that I would like to edit, I cannot see any data, as per attachment. I have watched various videos and the indicate that when you click on the file you would like to edit, there should be data table at the bottom, but I have only the name of the file. I.e. I would like to edit AUS_Fcast and this is the name I can see in the bottom left, no transaction is listed for editing. 

Please advise, what I am doing wrong, why I cannot see the space to edit each file?

Many thanks.Sample-of-Data.JPG

 
Posted : 22/09/2023 9:33 am
(@debaser)
Posts: 836
Member Moderator
 

Click on the button with the two down arrows on it at the top of the Content column (to the left of the one you currently have selected in that picture).

 
Posted : 23/09/2023 5:34 am
Share: