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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
siros92
Frequent Visitor

Help requested for connecting to REST API

Hi all, again hoping this wonderful community can help me out. Think there might be some generall learning for the community here as well! 

 

In Norway we have a significant amount of free publicly available data which the goverment collects, among these are AIS ship information from our coast. All of this is published in a rest API which requires you to get a token before calling the API and the token needs to be renewed every hour (so in reality everytime I would call the API). As i'm far from a computer expert I once again find myself in need of help here and it will likely need to be rather detailed (sorry just realizing my shortcommings in power query). 

 

The service offering access to the free data is called Barentswatch and they have also put together a short guide (not for power bi though) on how to connect to the API. it can be found here: https://developer.barentswatch.no/docs/tutorial

 

I belive that getting the response from the API in their examples through power query (so following their guide through) would be sufficent for me to be able to adopt the code to call different lists from their API. 

So, would it be possible to get help to 

- Understand how to access the API through power query and successfully send requests to the Barentswatch API? 

 

In advance thank you, and I appreciate and understand that this help request will take some time (hopefully not to much for someone who knows how to do this). 

Go for questions if I have been unclear.

 

 

 

 

1 REPLY 1
v-zhangti
Community Support
Community Support

Hi, @siros92 

 

You can refer to these documents and check if they can help:

Reports - Get Reports - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Read API Data with Power BI using Power Query (mssqltips.com)

Solved: Pagination of a REST API in Power Query using M - Microsoft Power BI Community

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.