none
Power Query API Request RRS feed

  • Question

  • Hello!

    I'm fairly new to all this so please forgive my nativity, attempting to use Power Query to access an API.

    I have a pre-configured url of:

    https://downloads.elexonportal.co.uk/file/download/SSPSBPNIV_FILE?key=XXXXXXXXXXX

    Which spits out a csv file, 5 columns with thousands of rows of data - happy days.

    What I want to do is define the parameter "Settlement Date" (in date format) to a specific month, any ideas?

    Any help would be great,

    Thanks,

    Alex

    Thursday, December 15, 2016 4:31 PM

Answers