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
darrenfishell
Advocate II
Advocate II

Unpack nested API response to separate tables, in Pro workspace, without replicating API call

I have a query to an API that includes a nested column that contains multiple records for each record in my response. 

I'd like to break these out into separate tables, given the different granularity, but I am also working with a Pro license and therefore cannot use computed entities. 

I've also noticed that dataflows do not preserve the contents of record or list columns for unpacking within a dataset pulling from that Dataflow (this would also solve my problem). 

Is there any way to either: a) have a staging query that pulls in the API content or b) retain the Record or List column content from the Dataflow?

2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi @darrenfishell 

 

You can Duplicate or Reference the API response query to create multiple queries in PQ in Power BI Desktop, and expand it to different granularity. Then publish this dataset to a workspace. If you want to use separate tables from this dataset in other reports, connect this dataset with DirectQuery mode. This is the only workaround I can think of. 

 

Best Regards,
Community Support Team _ Jing

Thank you! As I understand it, each query that references the API response query will run that full script each time. So, if I had three references, it would run through the API request three times, correct? 

I'd like to just hit the API once, have it stored in local memory and then work to unpack that local copy in subsequent steps, if that's possible without computed entities. 

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.

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.