Escape character for SAP BW connector?

Anonymous · ‎04-09-2019

Does anyone know if there is a way to incorporate an escape character in the SAP BW Connector? Someone in my company long ago had the brilliance to use the "/" character in a Logon Group and I haven't been able to figure out how to escape this character with the .NET3.0 connector. I'm able to connect to use connections that don't require the "/" character, but I'm struggling with logon groups that require it....

Suggestions?

SAP Connector 0.png SAP Connector 1.png SAP Connector 2.png

Thank you,

Rob

Aron_Moore · ‎04-09-2019

Could you try to do it in the query editor? Pass 'A/P' as a parameter in the connection function?

https://docs.microsoft.com/en-us/powerquery-m/sapbusinesswarehouse-cubes

Anonymous · ‎04-10-2019

Not really.... The component of the connection that's breaking down is that the Group's name has a forward slash / in its string, which breaks the syntax of the connection URL because it interprets the / as defining a new subdirectory. The only component of the connection that can be parameterized in Power Query is the FQDN of the server (e.g. foo.bar.com)