[ItemNotFound] Dataset xxx is not Push API dataset.

Hi khoaphan ,

Based on the error message received, it appears that your dataset does not qualify as a push dataset. However, please note that REST API Push Datasets - Datasets GetTablesInGroup only supports push datasets. For further details, I recommend referring to the official documentation provided below.

Push Datasets - Datasets GetTables - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Dataset {dataset_id} is not Push API dataset - Microsoft Fabric Community

The problem is you are trying to retrieve the table on the exisiting dataset, which is created from PowerBI Desktop/PowerBI Service. In such case you couldn't able to use this API.

 

This API is supports only Push DataSet

 

So what is Push DataSet ? 

Instead of creating the dataset from PowerBI Desktop/Service,you need to create it using API (Push Datasets - Datasets PostDatasetInGroup)

---

In the event that your dataset is not a push dataset, you can refer the following thread to get it:

Get table list:

Solved: How to get a tables list from datasets published w... - Microsoft Fabric Community

Get column names(for import mode):

Solved: How to extract all the column names from a 'Table'... - Microsoft Fabric Community

#"Column Names" = Table.TransformColumns(#"Previous Step", {{"Data", Table.ColumnNames}}),
#"Expanded Data" = Table.ExpandListColumn(#"Column Names", "Data")

Best Regards