Forum Discussion

clno1's avatar
clno1
Frequent Visitor
3 years ago

dataformat.error we couldn't parse your query string because it was improperly formatted

Hi There,    (Please see latest comment for current situation).   Got an issue building my first ever custom connector, wondered if folk here may be able to help? Here's my .pq file (no option to...
Need Help
clno1's avatar
clno1
Frequent Visitor
3 years ago

A quick update - I changed 

LoginUri = authorize_uri

to

LoginUri = AuthorizeUrl

Under the StartLogin function.

This actually got me further on, in that now I am repeatedly asked to approve access to the scope defined within the code, which feels like things are working better than they were before.

However, now I get. 

"dataformat.error we couldn't parse your query string because it was improperly formatted"

And this is what I'm struggling to solve now.

 

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    Hi clno1 

     

    Does it indicate on which row of codes this error may occur? I didn't find any possible solutions/website links related to this error message. I have no idea ☹️ sorry...

     

    Best Regards,
    Community Support Team _ Jing

    • clno1's avatar
      clno1
      Frequent Visitor
      3 years ago

      Hi @v-jingzhang

       

      I'm not quite sure how to get any greater level of debugging information, and so at the moment, no I don't have any better information to go on.

       

      I've enabled the logging in PBI desktop and this doesn't give me anything, next step I'd planned was for me to try and enable the trace option in Visual Studio but I'll be honest, that's a little bit beyond me at the moment - I have no idea where to insert the code that will enable the tracing.

       

      My other plan was to try this against a totally different endpoint and see if I get similar issues. Whilst not foolproof, that way I can determine whether it's likely my code, or some sort of incompatibility between PBI and Zoho.

       

      Also, I wonder if there is a way to decompile / reverse engineer one of the existing built in connectors as there is one for Zoho Connect, which is a different product by the same vendor - wondered if that might shed any light on where I'm going wrong.

       

      Be interested in your thoughts, thanks for taking the time.

       

      Cheers,

      • hariphy45's avatar
        hariphy45
        Regular Visitor
        3 years ago

        Hi clno1  have u found the solution for the problem, I am also facing this same exact problem while  integrating powerbi with one of zoho's services . Anything woud be of great help