Power BI Online return Credential Invalid Error on Anonymous Access of API URL

Hello Vicky_Song,

I'm using a webservice URL as datasource.

This is working on in Power BI Desktop, but don't work in Power BI Service.

Hello there,

I can refresh the dataset using a local URL and a web URL, but in both cases the error is exactly the same.

In both cases the Power BI Desktop working on and the Power BI Service is returning Timeout.

thx

ThalesFerraz, ttinsley, I'm trying to involve other engineers on this issue. I will keep you posted once I get any updates. 

Perfect Vicky_Song,

I'll be waiting anxiously.

I also register a ticket with this doubt.
If you return post here.

ThalesFerraz, your issue is escalated to more senior engineers. They request the screenshot of dialog box when you click on "edit credentials". And also provide the fiddler traces while refreshing.

Hello Vicky_Song,

I'm not sending the Fiddler result because there isn't needed.

The Power BI Service request the link without pass in my gateway.

See the image below.

below the requested image.

ThalesFerraz, can you share us one sample .pbix file with which we can check why the Power BI Service performs the same call multiple times?

Hi Vicky_Song,

Thx for asking.

This problem doesn't happen in Power BI Desktop. The multiple calls occur only in Power BI Service.

I also noticed that some calls that are removed from the Power BI Desktop still calls the BI Power Service (after republish).

I noticed this because the URL of the webservice has a login parameter. Some calls me brought the sign of a person who doesn't use our webservices to a few months.

I think the problem is the sum of multiple calls with calls removed.

I am running into a similar problem right now as well. I can see that you were able to solve the issue some month ago. Nevertheless, I am not able to understand what steps I would have to make to connect my datasets. 

What do you mean with 

Could you give me more information how you solved this and how this might relate to my case?

Kind Regards

Hello Lukas_Sieber,

Our company has a database system in AWS to store ERP data.

Previously we had created a webservice that searched the data in AWS and answered for Power BI.
As Power BI makes endless requests, our AWS database was overloaded.

Based on this we decided to separate the base that responds to the ERP of the base that responds to the Power BI.
We created a database in Azure.
And we set up an ETL to store in Azure (only the data we want to use in BI).

It got a little more expensive, but it was the best decision we made.

Today we have been able to use ERP and Power BI perfectly.

See u later.