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 PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors