Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 granulari...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Anonymous 

 

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.