Getting JSON data into Power BI

[tallalex85]

Hi everyone,

I'm new to PowerBI. I've been successfully pulling in JSON feeds from our forum API in PowerBI, but when I changed API version I've become a bit stuck!

The JSON feed looks like this:

But when I load this query into PowerBI I get:

If I convert to a table, I just get a empty table!

Any ideas what I need to do to pull in those fields?

Thanks for your help.

[tallalex85]

I've now tried saving the JSON feed to my desktop, and it works!

So presumably the error is to do with permissions/security - any ideas how I debug this? I don't get any error messages.

[v-chuncz-msft]

@tallalex85,

You may take a good look at The Advanced Editor.