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
Power BI DataViz World Championships

Power BI Dataviz World Championships

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

November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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.