Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Reply
sebbyp
Helper III
Helper III

Rest API connector help

‎01-18-2017 06:11 AM

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

Labels:
Message 1 of 3
1,519 Views
0
2 REPLIES 2
dkay84_PowerBI
Microsoft Employee
Microsoft Employee

‎01-18-2017 06:16 AM

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.  

Message 2 of 3
1,514 Views
0
sebbyp
Helper III
Helper III
In response to dkay84_PowerBI

‎01-18-2017 06:18 AM

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.

Message 3 of 3
1,511 Views
0

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All