Forum Discussion

Chris-F's avatar
Chris-F
Frequent Visitor
3 years ago

Power BI Rest API ServiceExceptionJson Valid Json

Hi

 

Am I the only one running into an issue where the ServiceExceptionJson is not returning a valid json in the Microsoft Power BI Rest API?

 

The JSON returned does not seem to be a valid json at all. Also does Microsoft have their Json Structure documented anywhere? I see there is an example on the Power BI REST API documentaitons, but it does not have when there is a value at the end of the json string "Table: Table1". which invalidates the Json

 

Thanks

Need Help

5 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    3 years ago

    Hi Chris-F 

     

    Can you please let us know which API you are calling.

     

    Your script you are using

     

    And then the error you are getting?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Have the exact same issue and cannot find help for it anywhere. I get that same piece of text at the end of the JSON, which makes it impossible to deserialize.

    • Chris-F's avatar
      Chris-F
      Frequent Visitor
      3 years ago

      Hey, So what i did was I basically just split the string by taking the 2nd from last }, and then everything after that I put that into a variable and do what I want with it. That has been working for me so far. There was no point in fighting to get microsoft to fix it

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Thanks! Ended up doing the same thing.