Scheduled refresh error
Hi Team, I am seeing the bellow error when the schedule refresh runs. If I download the pbix file and enter the creds locally, it does refresh and I can then republish. Why does a manual refresh work and not a scheduled refresh? We have a numer of data sources, so how do I tie this error back to which datasource is causing this failure. I've hashed out the server name. Processing errorThe operation has timed out Cluster *********.analysis.windows.net Activity ID6b31fb90-b482-4f16-9acf-8e36459a706b Request IDedcbcaf0-3f66-4392-a5c3-74a6f019a389 Time2022-03-15 14:03:57ZPowerBI Refresh Error
PowerBI App + Azure SQL Database(Serverless, Gen5, 2Vcores) with autopause after 1 hour. PowerBI fetches the data from Azure SQL Database using a SQL view with under 15M records everyday. This refresh takes about 10 minutes to refresh in PowerBI desktop. When I refresh it manually on PowerBi web, It takes under 5 min. But When I am trying to schedule the dataset refresh, it throws an error. ------------------------------------- Last refresh failed: Tue Jan 12 2021 13:44:23 GMT+0530 (India Standard Time) There was an error when processing the data in the dataset.Hide details Processing error: Microsoft SQL: Server provided routing information, but timeout already expired. Cluster URI: WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net Activity ID: 55091bfd-ce22-4ac6-b38b-7c199de0d392 Request ID: a3480078-1a6f-4afd-adc1-3f71cb734436 Time: 2021-01-12 08:14:23Z ---------------------------------------------------------------------- Can this be because of the serverless setup of the Azure Sql db with an autopause feature after 1 hour. Kindly help!!!Report Refresh in Progress using Gateway
Hello Guys, I have a problem with the schedualed refresh of my report using gateway on premises I set up all file locations and credintials for my laptop and made a schedualed refresh at 12:00 But it have been more than half an hour and still it is in progress , although it doesn't take a few seconds manually ( Small dataset ) So what is the problem ?Dataset updates but visuals on report won't
Hello all, I'm having trouble with a report I have set up. It's a direct connect to a SQL databse which updates every 15 minutes. I have limited the report to only show data between 6 and and 10pm each day and limited it to only show Todays data in the query. I can see the dataset refreshing within power bi online however when the report hits 10pm it just stops. So the next day if I refresh the dataset is showing as updated but the visuals on the report still only show from the previous day. It means that I need to manually share the report every morning. Has anyone exprienced this before or can you shed some light onto why this would be? Cheers, Graeme
