Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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...
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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
147 | |
85 | |
66 | |
52 | |
46 |
User | Count |
---|---|
215 | |
90 | |
83 | |
66 | |
58 |