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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lbudack
Advocate III
Advocate III

Can't add web sources to gateway cluster

I have some web APIs that I'm trying to add as data sources to our gateway cluster. They all work just fine when I refresh them in the desktop report, but when I try to add all but 2 of them to the gateway cluster, I get a "405 method not allowed" error. When I investigate the URL, I get the error "The requested resource does not support http method 'GET'." The settings for the two successful data sources are the same as these others except for the "GET" error. 

 

The data permissions for these items in the report are set to "anonymous" and privacy level "None". Screenshots below of what I'm seeing. Advice? 

 

 

Gateway 405 errorGateway 405 errorXML errorXML errorSettings in .pbix fileSettings in .pbix file

 

1 ACCEPTED SOLUTION

Hi,  @lbudack 

You  can refer this article,hope it will be  helpful to you:

https://community.powerbi.com/t5/Service/Post-Query-is-not-working-in-PowerBI-Service-at-schedule-re...

.

If you still have this issue for Power BI, you  can create a support ticket in Power BI Support to get further help.

https://powerbi.microsoft.com/en-us/support/ 

 

Best Regards,
Community Support Team _ Eason
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

9 REPLIES 9
blopez11
Resident Rockstar
Resident Rockstar

Since they are web APIs, I don't believe you need to add them to your gateway, we typically have not

We just publish the report to the service and provide the credentials for the different data sources (anonymous, basic, etc.)

 

There can be other issues, for instance, the root URL of the web service api must allow anonymous authentication

 

Good luck

Thanks. The gateway shows them needing to be added before we can use that gateway to refresh the report. I'm also wondering if the root URL changed from what it was before, as you mentioned. 

Without a picture to see what you are seeing, it is a little difficult to troubleshoot

If your report has other sources that use the gateway, the web sources should be optional to add

If your report only uses web sources, then you should have the option not to use the gateway

 

Can you show a screenshot of what you are seeing, you can blur out sensitive info?

Thanks,

@blopez11 

 

Here you go! Under datasets, things seem to look right (2nd screenshot) 

 

Gateway screenshot.JPG

 

Data source credentials.Data source credentials.

Hi , @lbudack 

Two tips need to pay attention  to:

1.The most common cause of a 405 Method Not Allowed error is entering the wrong URL.Any web servers are tightly secured to disallow access to improper URLs that the server isn’t prepared to provide access to.

Before going any further, therefore, double-check to ensure that you’ve entered the URL of the site you wish to visit correctly.

 

2.Make sure the setting for the datasource in Power BI Service within the data gateway cluster is correct.

 

Best Regards,
Community Support Team _ Eason

 

 

@v-easonf-msft 

 

Thanks! I suspect that's (#1) probably the issue as well. 

Hi , @lbudack 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.

Best Regards,
Community Support Team _ Eason

Thanks for your help, everyone. I'm working with the provider of the URLs to find a solution. I think there may be other issues here as well. Thanks! 

Hi,  @lbudack 

You  can refer this article,hope it will be  helpful to you:

https://community.powerbi.com/t5/Service/Post-Query-is-not-working-in-PowerBI-Service-at-schedule-re...

.

If you still have this issue for Power BI, you  can create a support ticket in Power BI Support to get further help.

https://powerbi.microsoft.com/en-us/support/ 

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors