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

[ThalesFerraz]

I can refresh the dataset normally by Power BI Desktop.
Using this (example):

Spoiler

let
    url = #"@LINK_WS"
        & "LOGIN=" & #"@LOGIN"  
        & "&SENHA=" & #"@SENHA"
        & "&NOME=WS_SC_LOTE_ATIV"
        & "&DATA_INICIO=2015-01-01"
        & "&DATA_TERMINO=2016-12-01",

    Source = Xml.Tables(Web.Contents(url)),
    
    Table0 = Source {0}[Table],
    #"Tipo Alterado" = Table.TransformColumnTypes(Table0,{{"COD_LOTE", Int64.Type}, {"COD_ITEM", Int64.Type}, {"QUANTIDADE", type number}, {"VALOR_UNITARIO", type number}})
in
    #"Tipo Alterado"

But I can't refresh the dataset in Power BI Online because it is returning the error below:

Spoiler

Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.Hide details

Activity ID:	be69162c-e02e-9249-c9b0-64b362864e72
Request ID:	0a540359-b538-586b-4441-9c2442d04d13
Status code:	200
Time:	Wed Jul 27 2016 11:32:09 GMT-0300 (Hora oficial do Brasil)
Version:	13.0.1500.472

More information:

• When click on "edit credentials" Power BI Online returns a dialog box. If I keep the "Anonymous" option and click "Sign In" works normally and the error disappears, but when trying to use the "Refresh Now" keeps returning the same error.
• The API URL don't works with credentials.
• The API URL return a XML table.
• The API URL only works on my server (computer).
• My Personal Gateway is working ON.

Edited 28/07/2016 15:39

Hello there,

The above error "with the credentials" happens before refresh.
After refresh the Power BI Online returns the error below:

Spoiler

Refresh history

ScheduledOneDrive

Details Type Start End Status Failure message

Show	On demand	28/07/2016 14:16:43	28/07/2016 14:48:25	Failed	There was an error when processing the data in the dataset.
Hide	On demand	28/07/2016 13:44:20	28/07/2016 14:16:43	Failed	There was an error when processing the data in the dataset.
Data source type:   Data source error: O tempo limite da operação foi atingido Cluster URI: WABI-BRAZIL-SOUTH-redirect.analysis.windows.net Activity ID: 24439e2e-de13-4c2e-a0ab-d12809ddbb30 Request ID: 3a72c3dd-2cb6-399a-918f-54a2af9d5303 Time: 2016-07-28 17:16:43Z

[Vicky_Song]

@ThalesFerraz, I'm not quite sure what is the root cause of your issue. Do you mind re-publishing the dataset to Power BI Service then refresh again?

[ThalesFerraz]

Hello Vicky,

Yes, i republished many times and the error remains.

What information do you need?
I really want to get a solution and can help as needed.

[ThalesFerraz]

Hello there,

Please. I need help to solve this.

I need to understand the reason for the refresh errors to deploy Power BI here.

The data refresh normally in Power BI Desktop, but don't refresh in Power BI Service.

 

 Edited  03/08/2016 16:45

 I'm aware that image above show Power BI Service received the publication of Power BI Desktop normally, but before publishing i refresh the Power BI Desktop data.

[ThalesFerraz]

Hi @Vicky_Song,

I found the scoring function you recently.

Sorry about that, but it can help me yet?

[ThalesFerraz]

Hello there,

Hello Power BI Team,

I posted this need a long time and the error persists.

I need help.

Power BI don't have a solution for this?

[Vicky_Song]

@ThalesFerraz, how about your first deleting all datasets in the Power BI Service and then republishing datasets and reports to the Service? I ever faced the same issue as yours. And my issue ended as resolved via that step. However, you need to be note that, your may need to recreate Power BI Dashboard after you publish the new dataset. 

[ThalesFerraz]

Hi @Vicky_Song,

Thx for asking

- I've tried after deleting the dataset and transmit again.

- I've tried after transmitting the dataset with a different name.

- I've tried after transmitting to a shared workgroup and to a personal workgroup.

- I've tried after transmitting using a machine that has the gateway installed and another machine without the gateway installed.

- I've tried after redoing the dataset from zero based.

- I've tried updating the dataset using a local URL (restfull) and using a web URL.

- I've tried updating the dataset using a Pro account and using Free account.

Nothing works

[Vicky_Song]

@ThalesFerraz, your issue is quite strange for me. I will try to invite other senior engineers.

[ThalesFerraz]

thx @Vicky_Song, i i'll wait.

I take this message to ask a detail.
How does the request process on Power BI Service?

I ask because the Bi Power Service returning Timeout error.
The problem may be in how the data are requested.

See the image below.

In case 1, we would not have any problems because if the error occurs in a specific request is only reduce the query period or increase the time for timeout.

But in case 2, if there is a timeout for the entire group of requests I would have to do.

[ttinsley]

I am having the same issue

[Vicky_Song]

@ThalesFerraz, @ttinsley what is the datasource you used in your Power BI reports? 

[ThalesFerraz]

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.

[ThalesFerraz]

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

[Vicky_Song]

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

[ThalesFerraz]

Perfect @Vicky_Song,

I'll be waiting anxiously.

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

[Vicky_Song]

@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.

[ThalesFerraz]

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 · Accepted solution]

Hello @Vicky_Song and @ttinsley

I will consider this case closed.

I had to replace all of our connections to the webservice for connections in a newly created database on Microsoft Azure.

Now we can refresh the dataset normally.

But I think that problem with the refresh using the webservice is linked to the fact that the Power BI Service performs the same call multiple times.

See the image below of my webservice LOG:

We would appreciate it if one day it is resolved.

[Lukas_Sieber]

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 

Spoiler

I had to replace all of our connections to the webservice for connections in a newly created database on Microsoft Azure.

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

Kind Regards

[ThalesFerraz]

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.