Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
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.
Check out the July 2025 Power BI update to learn about new features.