undefine"Power BI API Integration: Scheduled and Refresh Now Not Working After Publish to Web"

[vijayasanthi]

"Power BI API Integration: Scheduled and Refresh Now Not Working After Publish to Web"

    I recently integrated an API into Power BI and successfully pulled data using a bearer token for authentication. Everything worked well in Power BI Desktop, and I was able to view the data as expected. However, after publishing the report to the Power BI Service (web), neither Scheduled Refresh nor Refresh Now functions seem to be working.

Here’s the setup I followed:

1. API Integration: Used Power Query to call the API with a bearer token that periodically requires renewal.
2. Scheduled Refresh: Configured Scheduled Refresh in the Power BI Service but noticed that it doesn’t seem to update the data.

• Questions:

  • Has anyone encountered similar issues with API integration and scheduled refresh in Power BI Service?
  • Thank you in Advance

[Anonymous]

Thanks for tharunkumarRTK's concern about this issue.

Hi, @vijayasanthi 

May I ask if you have tried the tharunkumarRTK's method? Did the method he provided work for your problem?

In your description, the Scheduled refresh does not refresh the data, is there an error message?

Perhaps you can look at the refresh history and logs in the Power BI service to find out the specific error messages. This information can help you better understand the root cause of the problem.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tharunkumarRTK]

@vijayasanthi 

I am assuming you are passing the bearer token as a HTTP header. Did you supply the authentication details under Datasource credentails? if not open dataset settings and under "Data source credentails" click on edit credentails and keep 'Anonymous' as authentication mode and try to refresh your data.

For such API datasources I generally while editing the credentails I will turn off the test connection option and save the authentication.When you are performing the refresh the token will get generated an will be passed as a header to the actual API endpoint and refresh will complete. Try this approach and it should work. 

Or incase if you have any dynamic paramters in your API endpoint then it wont work from power bi service. You need to pass them as relative path argument or query parameter argument in Web.contents function. Please go through this video for more information 

https://www.youtube.com/watch?v=sv_upbpq_Cw

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!