JSON column is not expandable

Hi ImkeF 

thanks for your reply. I´ve already checked the blogpost you´ve mentioned, in my case there are lots of columns (about 100) with mixed types, so I checked also this post https://www.thebiccountant.com/2017/08/30/how-to-open-a-complex-json-record-in-power-bi-and-power-query/. 

By checking the code there it is already the code what PBI is doing automatically:

let
Source = Json.Document(Web.Contents("https://xxxx.xxxxxxx.com/rest/api/2/search?jql=filter=26502&maxResults=3000")),
#"Converted to table" = Table.FromRecords({Source})
in
#"Converted to table"

So most of the needed columns are expandable, only this one single column I need as well isn´t.

I´ve filtered a specific issue where I know there is an entry in the security level column and look what happens:

So I guess its regarding this:

But still the problem: I can expand the column when filtered rows, but then I can´t remove the filter from the list. So still the issue that I don´t know how to "tell" PBI that there is this specific column to expand.

With the syntax in the mentioned blog post I don´t know how to add it to the existing one with over 100 columns...

Is there anywhere an option to expand e.g. the number of columns PBI uses to profile the columns?

thanks and BR

Primlchen