Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
TCRUZ_MSFT
Frequent Visitor

Column Shows in Postman but not in Power Query

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

TCRUZ_MSFT_1-1750261160364.png

 

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

TCRUZ_MSFT_4-1750261635483.png

 

expanded attributes but only shows fields up to containerTagsourceID

TCRUZ_MSFT_3-1750261525629.png

 

I am using the same user credentials in both Postman and Power BI. Any suggestion to help me resolve this will be appreciated!

 

1 REPLY 1
MarkLaf
Memorable Member
Memorable Member

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?

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors