Forum Discussion

ishade's avatar
ishade
Regular Visitor
11 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
    11 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.

Praful_Potphode's avatar
Praful_Potphode
Icon for Super User rankSuper User
11 months ago

Based on the screenshot,you will have to expand your data and convert it into a table.

Then You can try below step in power query

 

the number highlighted shows the number of records you want from the table