Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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...
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.
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. 😃
Thats it!!!!
Thank You so much for your help and patience
Do you guys know how to get multiple observations in the same table?
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.
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!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |