schedule refresh not triggering

2 Topics

undefine"Power BI API Integration: Scheduled and Refresh Now Not Working After Publish to Web"
"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: API Integration: Used Power Query to call the API with a bearer token that periodically requires renewal. 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
vijayasanthi
1 year ago Place Report Server
754Views
0likes
2Comments
Schedule refresh not triggered.
Hi Team, Please pardon if this has ben already discussed. I have a schedule refresh that does not triggered automatically and we have to perform the maual refresh by clickin on the Refrehs Now everyday. This was working about 2 months ago but over suddent stopped. we have recreated the refresed several times to no success. Steps already done: I have rule out credentials since the refresh now works. And other reports with same credentials connecting to the same sql server are workng fine. I have rule out bugs since we just upgraded the server to January 2024 version. I have not ruled out the actual report (errors in formulas or calculations) and data issues (incorrect values) since the refresh now actualy updates the information on the report. Tested connection to the data source (a SQL Server using a service account) from the PBI Report Server. An dalsto using Powershell and both were succesful. The refresh runs at 11:20 Mon to Fri and before this time there are refreshes that run successfully. From the Power Bi report Server stand point is there anythign else I can check? could this be an issue with th db ReportServer and ReportServertemp database? Thank you in adv
Solved
DBailey
2 years ago Place Report Server
1KViews
0likes
3Comments