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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ThalesFerraz
Helper III
Helper III

Power 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):

 

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 demand28/07/2016 14:16:4328/07/2016 14:48:25FailedThere was an error when processing the data in the dataset.
Hide
On demand28/07/2016 13:44:2028/07/2016 14:16:43FailedThere 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

 

Sincerely,
Thales Ferraz
1 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:

 

Capturar.PNG

 

We would appreciate it if one day it is resolved.

Sincerely,
Thales Ferraz

View solution in original post

22 REPLIES 22

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors