topic Re: Push Datasets GET Tables no table information in Developer

Push Datasets GET Tables no table information

KieranNZ — Mon, 25 Mar 2024 20:29:05 GMT

I've created a new Push Dataset using the documentation example request payload found here

When calling GET https://api.powerbi.com/v1.0/myorg/groups/<groupID>/datasets/<datasetID>/tables

However I'd expect to see this information...

Re: Push Datasets GET Tables no table information

lbendlin — Tue, 26 Mar 2024 00:20:46 GMT

This API call Push Datasets - Datasets GetTablesInGroup - REST API (Power BI Power BI REST APIs) | Microsoft Learn

really only returns the table names. You should be able to get the other details via Powershell.

Re: Push Datasets GET Tables no table information

KieranNZ — Tue, 26 Mar 2024 01:00:42 GMT

Apologies, misread your response initially. So table details must be accessed via PowerShell cmdlets?

Re: Push Datasets GET Tables no table information

lbendlin — Tue, 26 Mar 2024 01:03:18 GMT

You didn't misread, I corrected my answer.

From my experiments with Push datasets that seems to be the case.

Re: Push Datasets GET Tables no table information

KieranNZ — Tue, 26 Mar 2024 01:14:12 GMT

Ok, thank you. I will mark as accepted once I confirm my end. Appreciate the help

Re: Push Datasets GET Tables no table information

KieranNZ — Mon, 01 Apr 2024 22:19:58 GMT

@lbendlin unfortunately the PowerShell script also returned no table information, just the name (using the PowerBI cmdlets).

I have taken a different path for solving my problem of replicating a core dataset for a subset of source data, using a combination of PBIX import and update parameters via the PowerBI REST API. For others interested, I won't describe it in detail but hopefully this screenshot will get you started...

This doesn't resolve the original issue of no table info returning from API, so I will leave this post unsolved.