topic Re: Use API for datasets from Power BI Desktop in Developer

Use API for datasets from Power BI Desktop

MiKeZZa — Wed, 25 Oct 2017 10:00:08 GMT

Hi all,

We're trying to see which tables are used in a dataset. Right now we're trying to achieve this with the API. We want to use the option to list all tables. This works fine for with the API created datasets, but for datasets that come from reports that are designed in Power BI Desktop (all of them unfortionately) we get this error message:

..... is not a push api dataset

In the datasets window in Power BI web interface API-Access has value --.....

Is this not possible at all? Or are we doing something wrong?

Re: Use API for datasets from Power BI Desktop

Eric_Zhang — Thu, 26 Oct 2017 03:13:40 GMT

@MiKeZZa wrote:

Hi all,

We're trying to see which tables are used in a dataset. Right now we're trying to achieve this with the API. We want to use the option to list all tables. This works fine for with the API created datasets, but for datasets that come from reports that are designed in Power BI Desktop (all of them unfortionately) we get this error message:

..... is not a push api dataset

In the datasets window in Power BI web interface API-Access has value --.....

Is this not possible at all? Or are we doing something wrong?

@MiKeZZa

At this moment, the REST API Get Tables only supports to get tables from the datasets created via REST API as well. It is not supported to get tables from a dataset published from Power BI desktop. You can submit your idea at Power BI Ideas and vote it up.

Re: Use API for datasets from Power BI Desktop

Anonymous — Thu, 21 Nov 2019 15:47:27 GMT

Hi,

At this moment, the REST API Get Tables only supports to get tables from the datasets created via REST API as well. It is not supported to get tables from a dataset published from Power BI desktop.

Now, I assume it's still true?