Backward Deployment
Hello ! I have a deployment pipeline in this order : A (Development) -> B (Preproduction) -> C (Production). This is the standard order of the workspace, but there were some reports that have been created directly in B, so is it possible to deploy from B to A? without unassigning the worskpace from the actual pipeline. Thank you.
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 ..
