TMSL Alter Column Description
I am a noob in TMSL and I need your help. I am trying to add a description to the column in Power BI Services with a command: { "alter ": { "object": { "database": "dataset_test", "table": "005_SHIP_TO_LOCATIONS", "column":"CREATION_DATE" }, "column": { "name": "CREATION_DATE", "description":"This is the new description" } } } The error I get is: Unrecognized command: alter . Check path '['alter ']', line 2, position 13. Could you help me to make it work? This is Power BI Premium and I TMSL works for table name modification, but I can't figure out how to change the column description.
Data Gateway (DM_GWPipeline_UnknownError)
Hi, i've tried to get connection from my analysis service to my power bi service with data gateway and get following error: GatewayPipelineErrorCode=DM_GWPipeline_UnknownError GatewayVersion= InnerType=AdomdErrorResponseException InnerMessage=<pi>Parser für XMLA (XML for Analysis): the'[email protected]' value of the 'effectiveUserName' xml for analysis property is not valid .</pi> InnerToString=<pi>Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Parser für XMLA (XML for Analysis): the [email protected] of XMLA-Eigenschaft (XML for Analysis) 'EffectiveUserName' is not valid. bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA) bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() bei Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync()</pi> InnerCallStack= bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA) bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() bei Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync() ([1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException.StackTrace:) bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA) bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) bei Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() bei Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync() I've done my mapping of Username correct i think. Mapped my Office Account to my Domain Adress. Can anybody help me?? Thanks!!!!