Forum Discussion
Refreshing data from REST API
Have you tried to follow the article below to configure Shceduled 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
Hi
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
Did this get resolved? I am having same issue.
Yes this did get resolved. It was the configuration of the API on the developers side. The developer had fixed the API for me.
