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

Don'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.

Reply
JasonBurdetts
New Member

REST API Datasource and Power BI Service

I have a small REST API running as a service in Azure that I would like to use in the Power BI Service.  It is protected by a Bearer Token  that is provided as a header parameter in the query.  The connection uses Anonymous credentials.

 

When I connect to this via Power BI Desktop, it works and I can retrieve the data. After publishing to the Power BI service, the data refresh fails. I can see the URLs in the connections, and the credentials are also set anonymously as I expected. However, in the connections view, these URLs are turning up in areas I did not expect, and consequently I think my reports are try to refresh from the wrong endpoint.

 

Why are the URLs appearing in both On-Premises Gateway and Cloud connections? What can I do to correct the situation? I realise I may not have included all information, but I am not sure what is needed to diagnose the problem. See image below (sensitive data redacted).

 

JasonBurdetts_0-1726107778765.png

 

Thanks!

 

1 ACCEPTED SOLUTION
v-tianyich-msft
Community Support
Community Support

Hi @JasonBurdetts ,

 

The Power BI service has limitations on dynamic data sources, which can cause refresh failures. Ensure that your REST API URL is static and not dynamically generated.
Also, choose to skip authentication when the gateway creates the connection.

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

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

View solution in original post

2 REPLIES 2
v-tianyich-msft
Community Support
Community Support

Hi @JasonBurdetts ,

 

The Power BI service has limitations on dynamic data sources, which can cause refresh failures. Ensure that your REST API URL is static and not dynamically generated.
Also, choose to skip authentication when the gateway creates the connection.

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

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

JasonBurdetts
New Member

To clarify, I do not known why the two "Web" urls are appearing in the data gateway.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.