Exrtract all workspace lineage list in service
Hi Experts, I need a help on how to extract the lineage of all workspaces, reports inside those workspaces and data models connected to that reports and data base that semantic model used to connect. layers: Workspace--> report--> semantic model--> data source(eg: AAS model). I can get list till 3 layers but unable to get details of 4th layer(data source) using admin monitoring folder data. I have fabric and platform admin access. could you please help me to know if there is a way to extract complete details in power bi service. Unfortunatly, I don't have access to run API's directly, your support helps to get the detailed list of all the workspaces in power BI service.
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
