Oklahoma Power BI User Group March 2023
Power BI Operations: Monitoring and Administration at Scale Building a report and deploying it is just the beginning! This session provides an overview of operational data that you should be monitoring as a Power BI administrator, data lead, or anyone who is responsible for more than one report. We will also cover the tools available out of the box and that can be built to operate Power BI at enterprise scale. Topics covered include: - Refresh monitoring - Refresh performance - User activities and report views - Capacity metrics and monitoring - Data and security lineage - Auditing user permissions
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
Excel Refresh
I have a datamodel connected into Excel as my users only are familiar with that and wont change to leveraging PowerBI. When I use the Analzye in Excel function or connect to the Data Model from PowerBI it works as it is intended, however where I am running into issues is with the constant need for the model to continiously refresh when my users are leveraging multiple filters with pivots leveraging measures created from PowerBI. When this happens it looks like it is consistently refreshing the data model. I've turned off all of the refresh options within the query but I can't seem to get passed this. Each time the data loads its taking close to 30-60 seconds to refresh its connection to the model. Any help or recommendations on alternative solutions to this is appreciated!!
