Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
sebbyp
Helper III
Helper III

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 2
dkay84_PowerBI
Microsoft Employee
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.  

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.