Using FRED Data

[Anonymous]

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.

[Anonymous]

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. 

[powerbime]

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.

[Anonymous]

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:

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. 😃

[powerbime]

Thats it!!!!

Thank You so much for your help and patience 

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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]

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]

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. 

[Aron_Moore · 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...

[ccalkins]

Link doesn't work

[powerbime]

this url is broken