topic Re: Refreshing data from REST API in Developer

Refreshing data from REST API

ChrisWeeks92 — Wed, 25 Apr 2018 07:56:51 GMT

I have a REST API setup as one of my datasets. What is the best way to get it to schedule refreshes, say 3x a day like 8am,12pm,3pm to capture the latest data in my report.

My REST API code is as follows. Is there a line i should add to the API code or any other way that i can get this to update automatically.

let    
url = "API LINK HERE", 
body = "{""Username"": ""xxxxxxxx"", ""Password"": ""xxxxxxxx"", ""CustomerID"": ""x""}",   

Source  = Json.Document(Web.Contents(url,   [ 
     Headers = [#"Content-Type"="application/json"],
     Content=Text.ToBinary(body)   
]   
)   
),
in
    #"Renamed Columns1"

Re: Refreshing data from REST API

v-micsh-msft — Thu, 26 Apr 2018 10:31:45 GMT

Have you tried to follow the article below to configure Shceduled Refresh?

Configuring scheduled refresh

If yes, what is the error messages?

If there are errors popped out, please share it here.

The code you posted should be the connection string stored in Power BI Desktop, which belongs to the web contents, please check the article below and see if it would work in your scenario:

Dynamic Web.Contents() and Power BI Refresh Errors

Regards,

Michael

Re: Refreshing data from REST API

ChrisWeeks92 — Thu, 10 May 2018 09:29:51 GMT

Sorry for the delay, i have been busy on other projects.

I have just tried Scheduled refresh as below. It comes back with

Failed to update data source credentials: Web.Contents failed to get contents from 'API URL' (405): Method Not AllowedHide details

I do have a personal gateway setup for this as i think it mentions that it would need a personal data gateway too but it comes back with "Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again." I have tried my Microsoft ID, API username/password and my computer login details. so any help will be much appreciated to where i am going wrong.

I don't quite understand where your second article is referencing in my case, what should i add/change in my file to refresh the API without actually opening the file and refreshing the data.

Thanks

Chris

Re: Refreshing data from REST API

aduval — Fri, 07 Sep 2018 12:28:04 GMT

Did this get resolved? I am having same issue.

Re: Refreshing data from REST API

ChrisWeeks92 — Fri, 07 Sep 2018 13:05:18 GMT

Yes this did get resolved. It was the configuration of the API on the developers side. The developer had fixed the API for me.