Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi Experts,
I noticed that some columns inside the "attributes" of the response I got are not showing in Power query, but is showing in Postman. For context, the below screenshot shows a column named "isBookLevel" in Postman, which is field that I need to include in my current report.
screenshot of data in Postman
In Power Query, I was able to expand all fields in the attributes column, but was only able to expand until the containerTagsourceID field, then the remaining fields no longer shows in Power Query:
attributes column
expanded attributes but only shows fields up to containerTagsourceID
I am using the same user credentials in both Postman and Power BI. Any suggestion to help me resolve this will be appreciated!
What is the type of data source and how are you connecting to it? Web.Contents or a more specific connector? Have you tried a more targeted query with a select-like query parameter?