Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

PostgreSQL ODBC to PowerBI Password

When PostgreSQL/AWS password is “11COEde1%23”, but when stored within the registry as a flat text entry, the “%” character is probably not considered during the handshake process. By adding the appropriate ASCII encode “%25”, which is equal to “%”, the connection worked perfectly fine.

 

By adding the appropriate ASCII encode “%25”, which is equal to “%”, the connection worked

 

Has anyone ran into this?

 

Thanks.

Need Help

3 Replies

  • JarroVGIT's avatar
    JarroVGIT
    Resident Rockstar
    6 years ago

    That is interesting and should be reported indeed, that sounds like a bug.

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    6 years ago

    Hi  Anonymous ,

     

    Based on my test, I cannot reproduce your issue here.

     

    What type of server do you connect to in the ODBC data source? And what version of Power BI Desktop do you use?

    I make a test using SQL Server, everything works well if my login contains % or +. And I am able to import data from the ODBC data source that conatins SQL Server connection in Power BI Desktop  2.76.5678.541 64-bit (December 2019). In your scenario, I would recommend you check if the password is correct, you can also verify if the ODBC connection works in Excel.

     

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      6 years ago

      Hi Anonymous ,

       

      Has your issue been solved? If so kindly mark my answer as a solution to close the case. Thanks in advance. Any other question, feel free to let me know please.