Forum Discussion
Error when connecting to report that uses DirectQuery to SQL Server
Please use on-premises data gateway instead of personal mode of on-premises data gateway. For data sources other than Azure SQL Database or Azure SQL Data Warehouse that use DirectQuery, and Enterprise Gateway must be installed and the data source must be registered to establish a data connection.
If you are using import mode to SQL Server, you can use personal mode of on-premises data gateway.
Please refer to following Matrix. Reference: https://powerbi.microsoft.com/en-us/gateway/.
For how to use on-premises gateway, you can refer to https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-sql/.
Best Regards,
Herbert
Underlying Error: PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: DM_GWPipeline_Gateway_BadUsernameFormat
Activity ID: e8bbd214-627a-40fe-a38a-f840409f349f
Correlation ID: f512dd3d-5b2c-1ae5-461d-b633a824505b
Request ID: 930fcca8-6a6e-eb1a-2dfd-65fb97a894b9
Time: Tue May 09 2023 21:45:24 GMT+0530 (India Standard Time)
Service version: 13.0.20626.62
Client version: 2305.1.13619-train
Cluster URI: https://wabi-uk-south-b-primary-redirect.analysis.windows.net/