Forum Discussion
Power BI can't parse a JSON response from SonarQube API
Hello everybody, I have a curious problem when querying the SonarQube API using the Web Get Data option. SonarQube is a tool used for continuous inspection of code quality. It contains various me...
v-lili6-msft
Community Support
Community Supporthi Anonymous
What is your M code in your power query, I think you need "Json.Document" to parse it.
Here is a blog, you could refer to it:
Regards,
Lin
hi v-lili6-msft ,
my M query looks like this after trying the solution. (Json.Document was part of the original query - the original looked the same as the one below if we omit the second line in the let block )
I am sorry, the image didn't go through.
M query