Forum Discussion

ishade's avatar
ishade
Regular Visitor
10 months ago
Solved

Syntax for TOPN on Source Statement of Power Query

Hi, I would like to setup a report to show data of a 'Event' table of Salesforce (Alexis).  I tried to prepare a DataFlow but got empty table but columns and got advise from raja1992 of the possible...
Tips and Tricks
  • Irwan's avatar
    Irwan
    10 months ago

    hello ishade 

     

    i am not sure but seems the last step is not correct.

     

    the M code should put the previous step

    you previous step is Navigation (sorry i dont write it in japanese)

     

    or else, you can use the ribbon button so you dont have to type the code manually (the selection from ribbon should automatically detect the previous step).

     

    Thank you.

ishade's avatar
ishade
Regular Visitor
10 months ago

Hi Irwan

Thanks for your kind correction. But I am sorry to report you that it still shows some syntax error as following ;

 

Irwan's avatar
Irwan
Super User
10 months ago

hello ishade 

 

i am not sure but seems the last step is not correct.

 

the M code should put the previous step

you previous step is Navigation (sorry i dont write it in japanese)

 

or else, you can use the ribbon button so you dont have to type the code manually (the selection from ribbon should automatically detect the previous step).

 

Thank you.

  • ishade's avatar
    ishade
    Regular Visitor
    10 months ago

    Hi Irwan

     

    Thanks for your kind comment to put Index with right name of previous step.

    But unfortunately, I did not make it since the 3rd. step does not reconignize the 2nd. one.,

    which would means I should focus on 2nd. step (yes, navigation) including access right.

     

    Anyway, closing this shred for a while, 

    I would like to appreciate your valuable time to support this matter. Have a nice day!!!