Solved: API with Header NOAA

zibster · ‎01-27-2020

Hi,

I am trying to connect to NOAA api and I was able to establish connection with Postman by using Token provided by NOAA in header field, but when i try to do the same in Power BI i am getting "Unable to connect" message.

Please help.

Z

mwegener · ‎01-27-2020

Hi @zibster ,

maybe this helps.

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=2ef3e9cf-...

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials

View solution in original post

mwegener · ‎01-27-2020

Hi @zibster ,

maybe this helps.

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=2ef3e9cf-...

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials

zibster · ‎01-27-2020

Hi Marcus,

This is perfect 🙂 !!! Thanks

amitchandak · ‎01-27-2020

Refer , if these can help

https://community.powerbi.com/t5/Data-Stories-Gallery/U-S-Weather-Analysis/td-p/58483

http://www.victorrocca.com/weather-analysis-follow-up-parsing-through-noaas-data/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

zibster · ‎01-27-2020

Hi,

The refered dashboard is build on static/ downloaded information, I am trying to do a daily refresh using API.

Thanks

Z

dtran · ‎01-27-2020

Would love to see how this can done dynamically.

I explored using NOAA data couple years ago. I ran into the same issue.

When I found Weather Underground, I was able to pull the data down via a daily API call, then insert the data into my database, then pull that data into a dashboard. Was a great solution until Weather Underground was acquired by IBM and the data was no longer free.

Have been looking for a replacement that is free but have not found one since.