dataset refresh failed

[shuaho]

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!

[Anonymous · Accepted solution]

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

[Anonymous]

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.

[Sweet-T]

Hey @Anonymous,

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

[shuaho]

thanks @Anonymous

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?

[Anonymous · Accepted solution]

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

[digs65]

I am having similar issue, but I believe mine is because I have used an excel file as one of my queries along with querys from OData feed.  Am I still able to schedule a refresh on a report that has multiple types of queries in it?  Thanks.

[shuaho · Accepted solution]

@Anonymous  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 !