Symptoms
Error while executing PowerBI Premium endpoint. The error message received is similar to the below:
Error: PowerBI Premium endpoint "Failed"
-Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: "The end of the input was reached.
The end of the input was reached.
{"error":{"code":"DM_GWPipeline_UnknownError","pbi.error":{"code":"DM_GWPipeline_UnknownError","parameters":{},"details":[]}}}
Error: DM_GWPipeline_Gateway_DataSourceAccessError -> A connection could not be made to the data source with the Name of 'MDW'. A task was canceled.. The exception was raised by the IDbCommand interface.
Cause
The issue was related to the gateway used to connect to the data source(s).
Resolution
- Investigate and fix any issues related to the gateway used for connecting to the data source(s).
- Ensure that the gateway is properly configured and operational.
Reference Ticket
32083