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
Azure DevOps pipeline to replicate Power BI report changes for various repositories (PBI workspaces)
Hello, here is my business request: -> we are having data from various countries and would like to have dedicated Power BI workspace for data from each country -> it will help us with permissions management, will clearly separate the data,... And technical setup so far looks as the following: -> as semantic models will have the same schema (table names, metric names), it means, that semantic models within each workspace will be using slightly different SQL query (which will gather data for the respective country) -> it's true, that maintenance of semantic models for multiple workspaces may be then be a little bit longer (as we will have to adapt changes for each workspace), but changes for semantic models are not frequent and usually we do bulk of changes together But I am now dealing with the technical question and what would be the best practice for development of Power BI reports, where we would like to reduce amount of duplicated work. Below is my idea for technical implementation: -> PBI reports are developed for one workspace within Azure DevOps repository, then merged through Pull request and then published into PBI workspace through Source control integration in PBI -> and I would like to have Azure pipeline, which will listen to the Pull request merge (basically any change in the master branch of that repository) and then will create similar Pull request in another repository (which is linked to another Power BI workspace), while replicating all the adapted changes for reports -> as was mentioned, schema of semantic models is the same between workspace, so it's only important for replication of Pull request with changed reports to keep proper connection (from Power BI report to semantic model), everything else can be simply copied => and my question really is, if you think, that this could be the right approach (having Azure pipelines to replicated PBI report changes into multiple repositories) and if yes, whether you could suggest to me some working Azure DevOps YAML pipelines examples ? many thanks in advance for any thoughts or suggestions
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!
Linked table source triggering dataflow refresh before scheduled time
How can I stop a dataflow from automatically refreshing when a linked table that is coming from another dataflow is refreshing? All I want is the scheduled refresh time to start the dataflow and not a linked table to trigger it. The problem is I have a Power Automate Flow that runs when the dataflow with the linked table completes on "Success". This causes a bunch of datasets to start their refresh, but I only wanted that to happen when the scheduled refresh was supposed to start. So these datasets are being updated twice each night. If I uncheck "Enable Load" on the linked table source would that stop that from occurring? However, what other issues could happen with other queries and datasets that are using that linked table downstream? Is there something I can do differently with the Flow to know only to start when the actual scheduled refresh is completed as Success?
