Scheduled Refresh Fails, Manual Refresh Succeeds
I have a Semantic Model that utilizes 5 data sources. One of the data sources (connected to Amazon Redshift SQL) keeps triggering a failure message 3-5 minutes into the scheduled refresh (error at the bottom of post). When I go into the connection settings, I see the password is reduced down to 8 characters (this might just be a visual thing, but either way). I then put the password in, Save, and trigger a refresh on the server again. This refresh always works. I've also tried making a new connection and replacing he existing one - same error occurs. So either the data source can't support scheduled refreshes or the correct password won't save. Has this happened to anyone else out there? Any ideas how to restore the automation to my refresh? Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support. [ValidateMarkupTags]<ccon>{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"[ccon][ccon]ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] connection to server at \"[SERVER STRING IS HERE]" ([ccon]<ip>52.26.233.171</ip>[/ccon]<ip><ip>52.26.0.0</ip></ip>), port 5439 failed: timeout expired\n[/ccon][/ccon]"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"10478"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"AmazonRedshift"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"[ccon]etl-workgroup.774598924186.us-west-2.redshift-serverless.amazonaws.com;bswift[/ccon]"}},{"code":"Microsoft.Data.Mashup.ValueError.NativeError","detail":{"type":1,"value":"10"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.SQLState","detail":{"type":1,"value":"08S01"}}],"exceptionCulprit":1}}}</ccon>
Gateway Unreachable
All are failing on Scheduled Refresh All reports work when manually refreshing. I have checked Gateway Status and I have chcked Connection to SQL Server. Cluster URIWABI-US-NORTH-CENTRAL-J-PRIMARY-redirect.analysis.windows.net Activity ID90a01224-d153-4fcb-836b-c4a3d71bd363 Request ID4ea3aefd-6daa-4b58-9b5e-c8e0c2be186a Time2025-11-22 16:35:01Z { "error": { "code": "DM_GWPipeline_Client_GatewayUnreachable", "pbi.error": { "code": "DM_GWPipeline_Client_GatewayUnreachable", "details": [ ], "exceptionCulprit": 1, "parameters": { } } } }
Power BI report server Schedule refresh
Hi, I have created a schedule refresh for my power bi report when i manually run that schedule refresh it works fine. So, just to test it out i have create a scheduled refresh for every 5 minutes and it's not starting automatically. So the last run was at may 6th 3:41 pm which i did manually and it refreshed fine. but after that it has been 24 hours did not run once. supposed to run every 5 minutes.
Report refresh failed when appending two sources (On prem(DB2) and cloud date source(Sharepoint))
Hi, I am appending two sources(On prem(DB2) and cloud date source(Sharepoint)) to produce as a single report.When Published and schedule report refresh, refresh fails with the below error. Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"SharePoint: Request failed: The underlying connection was closed: An unexpected error occurred on a send."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SharePoint"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"https://<orgname>.com/sites/"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Append1. Also, under Gateway connection, Cloud connection(Sharepoint connection is pointing to On Premise Gateway connection). Thanks in advance for your support. Thanks
sh, repScheduled data refresh on Google Analytics on Server (on-premise)
I want to refresh my google analytics' data on the server (on-premise) and schedule it (not manually) but I get this error. I have founded this: "Not all Power BI Reports can have a scheduled refresh plan created on them. If data source can be connected using only OAuth (e.g. Facebook, Google Analytics, Salesforce, etc.), then cache refresh plan cannot be created. At the moment, RS does not support OAuth authentication for any data source whether it is for paginated, mobile or Power BI reports." So does anyone know any other solutions? (Maybe using Flow or anything else?)Unable to have Scheduale refresh
Our organization is having some issues with our dataset not refreshing. We get the following message: xxx has failed to refresh. Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support. <ccon>DataSource.Error: <ccon>Microsoft SQL</ccon>: <ccon>"User does not have permission on table incident. Line:317, Position:10" RequestId: TDS;e9f194a2-a354-45e9-afa6-bbb94c69e71f;10 Time: 2023-09-05T08:32:02.5471599Z</ccon>. DataSourceKind = <ccon>CommonDataService</ccon>. DataSourcePath = <ccon>econa.crm4.dynamics.com</ccon>. Message = <ccon>"User does not have permission on table incident. Line:317, Position:10" RequestId: TDS;e9f194a2-a354-45e9-afa6-bbb94c69e71f;10 Time: 2023-09-05T08:32:02.5471599Z</ccon>. ErrorCode = <ccon>-2146232060</ccon>. Number = <ccon>40000</ccon>. Class = <ccon>16</ccon>. </ccon>. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: incident. How do we fix this issue? (Please explain in a way someone who isnt proficcient in Power BI yet would understand)
