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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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