Forum Discussion
Escape character for SAP BW connector?
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?
Thank you,
Rob
2 Replies
Aron_MooreSolution Specialist
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
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)