cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shuaho Frequent Visitor
Frequent Visitor

dataset refresh failed

 

Got below error when do  refresh 

 

Details Type Start End Status Message
Hide On demand 10/25/2018, 7:09:01 PM 10/25/2018, 7:09:01 PM Failed Scheduled refresh has been disabled.
Data source error: Scheduled refresh has been disabled because at least one data source is missing credentials. For refresh to succeed, you must provide credentials for all data sources. Please enter the data source credentials on the dataset settings page and then reactivate scheduled refresh.
Cluster URI: WABI-CANADA-CENTRAL-redirect.analysis.windows.net
Activity ID: beb6f600-7d62-4776-a3b0-a85c2667ce60
Request ID: e3b456cd-296a-22d5-ea94-8eaa815f759e
Time: 2018-10-26 02:09:01Z

 

 

The dataset was created by pull data from a restful api using M language. 

 

let
    url="http://api.....com/api/1.0/authentication",
    body = "{
              ""userName"":""ABC"", 
              ""password"":""123"" 
            }",

    jsonResult = Json.Document(Web.Contents(url,[Headers =[#"Content-Type"="application/json"],Content = Text.ToBinary(body) , Timeout=#duration(0,2,0,0)])), 
    token = jsonResult[accessToken], 
    location_url = "http://api.....com/api/1.0/sites",
    locationJsonResult = Json.Document(Web.Contents(location_url,[Headers =[#"accessToken"=token], Timeout=#duration(0,2,0,0)]))
        
in
    locationJsonResult

how do I do to make the refresh happen?

 

Thank you very much!

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: dataset refresh failed

@shuaho  If M has to 'fetch' data from a source, you need to supply some form of credentials, unless you can use anomyous.  Have you tried that option?


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


shuaho Frequent Visitor
Frequent Visitor

Re: dataset refresh failed

@Ross73312  thanks for replying.   Yes,  I need to set it as 'anonymous' credentials.  And set a 'GET' request reachable endpoint to make the refresh job work.  

 

Thanks !

5 REPLIES 5
Super User
Super User

Re: dataset refresh failed

In your Power BI Service, inside the workspace that houses this report, go into the "Settings" area and look for the Datasets section.  On this list should be your dataset for the report you are having trouble with.  Click on that report and look for a section on the right called "Data Source Credentials".  Check that each data source as I would suspect some will have a Cross in a circle and tell you that the credentials have failed.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


shuaho Frequent Visitor
Frequent Visitor

Re: dataset refresh failed

thanks @Ross73312

yes there are 3 yellow ciccles saying credential issues.

But when I try to set credentials, there are only 'anonymous, windows and basic' 3 ways
. None of them meets with our case.
I would expect the refresh job run the M script that generates the dataset, so the script will automatically get authentcated itself and fetch data.

Is it possible?
Sweet-T Member
Member

Re: dataset refresh failed

Hey @Ross73312,

 

Any idea what to do if you can't access that section of the settings? (Data Source Credentials)
PBI Data Source Cred.PNG

Super User
Super User

Re: dataset refresh failed

@shuaho  If M has to 'fetch' data from a source, you need to supply some form of credentials, unless you can use anomyous.  Have you tried that option?


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


shuaho Frequent Visitor
Frequent Visitor

Re: dataset refresh failed

@Ross73312  thanks for replying.   Yes,  I need to set it as 'anonymous' credentials.  And set a 'GET' request reachable endpoint to make the refresh job work.  

 

Thanks !