Forum Discussion

sebbyp's avatar
sebbyp
Helper III
9 years ago

Rest API connector help

Hello community,  i am trying to use power bi to connect me to OECD economic database.  Can anybody help me work out what to do because when i use the link available on the website i can't find the dataset.

 

The website is

http://stats.oecd.org/Index.aspx?DataSetCode=MEI_CLI

2 Replies

  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    Microsoft Employee

    Go to Get Data and choose Web, then copy/paste the link in.  It worked for me and detected "Table 0" which had the monthly indexes.  

    • sebbyp's avatar
      sebbyp
      Helper III

      i would like to access the historical data not whats shown in the table on the page.  There are options under export with xml which i guess will do the job but i cannot get it to work.