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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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 ACCEPTED SOLUTION

Hi MarkLaf,

 

Thank you for the response. I was able to resolve the issue by adding api-version:4.0 in the call header, which I forgot to include in my POST call in Power BI. 

View solution in original post

2 REPLIES 2
MarkLaf
Super User
Super User

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?

Hi MarkLaf,

 

Thank you for the response. I was able to resolve the issue by adding api-version:4.0 in the call header, which I forgot to include in my POST call in Power BI. 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.