Push Datasets GET Tables no table information

[KieranNZ]

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...

[lbendlin]

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.

[KieranNZ]

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

[lbendlin]

You didn't misread, I corrected my answer.

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

[KieranNZ]

@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.

[KieranNZ]

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