Token EOF expected error

Question

I tried simple nested query in power query editor,

it gives Token EOF expected error. what is the reason

Answer 1

Hi @theja gamage ,
The Power Query IF and IF ELSE statements are case-sensitive and they require lower-case. Change IF to if.