Unable to create sub connections in service
This is a dataflow that was working up until last night's refresh cycle. This particular part had been working for at least a year. The same PQ logic IS working in a local PBIX file w/o issue. My dataflow is connecting to a Dataverse environment. Connecting to "tables" works without issue. Where I am running into issues is attempting to access the metadata attributes that contain the values for multiple choice columns. To do so I'm using the function below: In both service and local PBIX. The first prompt for credentials is addressed with Anonymous In the PBIX the second prompt is addressed with my Org account. In the local PBIX this is recordable as two different credentials. The first is for https://org<number>.crm.dynamics.com the second is the expanded Attribute metadata url that RelativePath produces. Today I'm unable to create a second credential "specific" to the relative path url in the service which prevents refreshing this table. Is anyone else seeing this? Am I approaching this wrong? let Options = (TableName as text, OptionSetName as text) => let // Source = Json.Document(Web.Contents("https://" & ORGURL & "/api/data/v9.0/EntityDefinitions(LogicalName='" & TableName & "')/Attributes(LogicalName='" & OptionSetName & "')/Microsoft.Dynamics.CRM.MultiSelectPicklistAttributeMetadata?$select=LogicalName&$expand=OptionSet($select=Options)")), Source = Json.Document( Web.Contents(DataverseEnvironment, [ RelativePath = "/api/data/v9.0/EntityDefinitions(LogicalName='" & TableName & "')/Attributes(LogicalName='" & OptionSetName & "')/Microsoft.Dynamics.CRM.MultiSelectPicklistAttributeMetadata?$select=LogicalName&$expand=OptionSet($select=Options)" ] ) ), OptionSet = Source[OptionSet], Options = OptionSet[Options], #"Converted to Table" = Table.FromList(Options, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"Value", "Label"}, {"Value", "Label"}), #"Expanded Label" = Table.ExpandRecordColumn(#"Expanded Column1", "Label", {"UserLocalizedLabel"}, {"UserLocalizedLabel"}), #"Expanded UserLocalizedLabel" = Table.ExpandRecordColumn(#"Expanded Label", "UserLocalizedLabel", {"Label"}, {"Description"}), #"Set Column Types" = Table.TransformColumnTypes(#"Expanded UserLocalizedLabel",{{"Value", Int64.Type}, {"Description", type text}}) in #"Set Column Types" in Options
how to change the service account in On Prem gateway
Hello everyone ! I am trying to connect a network directory using Power Automate . As you know the first step is to install and register gateway . I did the same but to connect to network folder/ directory - I got to know that we need to change the service account present in Service Settings ! I tried to change with my Windows User name and password , it is continuously throwing password / user incorrect error . Can you please guide me what needs to entered in Service Setting --> Change Service Account ? Please note that we have dedicated service account and I am trying to use the same ..
Severe Gateway Performance Degradation & High CPU Post-Migration (ASYNC_NETWORK_IO Waits)
Hello everyone, I am looking for some architectural and performance troubleshooting advice. Following a server migration on March 27, 2026, our On-Premises Data Gateway has experienced a massive and continuous spike in CPU usage and data processing duration. Standard refreshes are now taking twice as long to execute. Environment & Architecture: OS: Windows Server 2016 Standard. Hardware: AMD EPYC 9274F 24-Core (30 logical processors), 192 GB RAM. Co-hosted Services: The physical server hosts the Gateway, SQL Server 2019, and Remote Desktop sessions. Storage Configuration: Drive I (4KB allocation size), Drives E and D (64KB allocation size). SQL Shared Memory protocol is ON. Symptoms & Observations: Gateway Logs: We are seeing AsyncOperationStreamingCancelledException errors related to the spooler (No more this error after tuning applied on 24 April). SQL Server Waits: Running sp_WhoIsActive during Gateway execution shows a high volume of blocked sessions with ASYNC_NETWORK_IO wait types. This specifically impacts databases located on Drive D (logs on Drive E). Performance for a database located on Drive I remains completely normal. OS Impact: RDP sessions for users on this server periodically become unresponsive due to the resource drain. Troubleshooting Steps Taken: Prior to April 20, the Gateway ran on default settings with the Spooler and Mashup Cache located on Drive C. I have since applied the following tuning: Settings from 20.04 to 24.04 Container Tuning - from 20.04 to 24.04: Enabled overrides and adjusted Mashup pool containers. Currently set to MashupDefaultPoolContainerMaxCount = 4 and MashupDefaultPoolContainerMaxWorkingSetInMB = 8192. I/O Relocation: C drive Streaming: Toggled StreamBeforeRequestCompletes to TRUE. Memory Management: Reduced SQL Server max server memory to 140 GB Settings from 24.04: Container Tuning : Enabled overrides and adjusted Mashup pool containers. Currently set to MashupDefaultPoolContainerMaxCount = 12 and MashupDefaultPoolContainerMaxWorkingSetInMB = 4096. I/O Relocation: Moved the SpoolerDirectory and Mashup Persistent Cache to Drive I to alleviate potential disk contention. Streaming: Toggled StreamBeforeRequestCompletes to FALSE. Memory Management: Reduced SQL Server max server memory to 135 GB Current Status: These changes successfully reduced Gateway CPU usage and processing duration compared to the post-migration peak. However, performance is still significantly worse than it was before the migration. Has anyone experienced similar ASYNC_NETWORK_IO bottlenecks between local SQL Server instances and the Gateway Mashup engine after hardware/server migrations? Thank you in advance for your insights. EDIT: 30.07.2026 Created new gateway (testGateway) on different VM. Moved couple of reports to new testGateway. The issue is still there. Performance seems bit better, but still there is ASYNC_NETWORK_IO bottleneck.
API equivalent of "Configure Connection > Connect" for Dataflow Gen2?
We're automating Dataflow Gen2 onboarding for unattended refresh using the Fabric REST API. Our service account owns an on-premises gateway connection (OAuth / Organizational account) that reports Online via testConnection. We create or update dataflows with this connection in queryMetadata.json — service account is the item owner and connection owner. Refreshes fail with "Credentials are required" until we manually open the dataflow in the portal and click Configure Connection > Connect. After that single click, refreshes work indefinitely. Is there any API or programmatic method that replicates what "Connect" does? We cannot use manual interaction per dataflow, and cannot change to Basic/Windows credentials and must use OAUTH2
Can Scorecard(Goals) be used for custom Power BI visuals?
Hi everyone, I'm evaluating Power BI Scorecards (Metrics) for KPI/KRI tracking. During testing, I noticed that a Scorecard creates an associated semantic model that is visible in Fabric/OneLake. However, the semantic model appears to be DirectQuery-based, and I haven't been able to use it the same way I would a normal semantic model for reporting. My goal is to: Maintain KPI/KRI values in a Scorecard using manual data entry check-ins Build custom Power BI reports using that data Create visuals such as bar charts, pie charts, stacked columns, trend charts, and executive dashboards My questions are: Is the automatically created Scorecard semantic model intended to be used as a source for custom Power BI reports? Can regular check-in be used as a data entry point? Are there DirectQuery or modeling limitations that prevent custom visualization? Has anyone successfully used Scorecard metric data to build custom report visuals outside the Scorecard experience (other than the trend view)? I can see the associated semantic model in Fabric, so I'm trying to understand whether I'm missing a configuration step or if the model is only intended to support the Scorecard itself. Thanks in advance!
