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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Using FRED Data

Hi,

FRED (Federal Reserve Econcomic Data) is a great website that offers all kinds of economic series data free to the public, and I'm wondering if anyone can recommend a good connector to import these data series into BI.

Thank you in advance.

1 ACCEPTED SOLUTION

API can be tough. Basically, it's like getting from a web source. Check out these instructions: https://blogs.msdn.microsoft.com/charles_sterling/2016/05/25/how-to-call-rest-apis-and-parse-json-wi...

View solution in original post

32 REPLIES 32
Anonymous
Not applicable

Hi, @powerbime I can see attribute:value in the list in your screen shot. Do you need to scroll to the right to see the column? I recommend unchecking all but the value and date. 

6A48EA60-A98F-44AB-8EE7-C9C51FF2D3B4.jpeg

 

Sorry for the misunderstanding I sent you the screen that you had in your reply when I sent this screen which is mine you will see not the same fields you have.

Capture4.PNG

Anonymous
Not applicable

Hi, @powerbime. I realized that when I checked your screenshot to confirm your code, you were actually showing my screenshot with my code. Two of your screen shots do show an error in your code:

 

Annotation 2020-06-23 104833.png

https://api.stlouisfed.org/fred/series/observations?series_id=GNPCA&api_key=YOURAPIHERE

 

You need to add /observations where the red caret and text indicates, between the first word series and the question mark. 

 

I hope you enjoy many happy uses of the FRED data. 😃

 

Thats it!!!!

Thank You so much for your help and patience 

Anonymous
Not applicable

You're very welcome @powerbime . Glad to pass along some of what I've learned.

Anonymous
Not applicable

Do you guys know how to get multiple observations in the same table?

 

Anonymous
Not applicable

The instructions I gave to powerbime above will give multiple observations in the same table. Do you mean observations from multiple series? You can add a dates table to your BI and merge on dates to get multiple data series in the same BI table.

Anonymous
Not applicable

I will try that, I was trying to get multiple observations from different series without having to write a python script for it but I will try merging the different data. Thanks! 

 

Anonymous
Not applicable

You can definitely pull them in separately whether with Python or the web connector and use PowerBI to combine if that's necessary. I tend to keep them in their own tables and combine in visuals. 

API can be tough. Basically, it's like getting from a web source. Check out these instructions: https://blogs.msdn.microsoft.com/charles_sterling/2016/05/25/how-to-call-rest-apis-and-parse-json-wi...

Link doesn't work

this url is broken

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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