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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

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
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.