Forum Discussion
Kudo CommanderPower BI Online return Credential Invalid Error on Anonymous Access of API URL
I can refresh the dataset normally by Power BI Desktop.
Using this (example):
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:
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:
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. | |||||||
|
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.
22 Replies
Vicky_SongImpactful Individual
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?
ThalesFerrazHello 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.