Forum Discussion
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
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
expanded attributes but only shows fields up to containerTagsourceID
I am using the same user credentials in both Postman and Power BI. Any suggestion to help me resolve this will be appreciated!
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.
2 Replies
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.
