topic Using Rest API to List Tables Group in Developer

Using Rest API to List Tables Group

Phil_Seamark — Thu, 21 Jul 2016 19:43:51 GMT

I am trying to use the REST api to insert rows in a Table that resides in a Shared Workspace.

I can list all the groups I can see using:

https://api.PowerBI.com/v1.0/myorg/groups

And using the relavant groupid I can list the datasets using

https://api.PowerBI.com/v1.0/myorg/groups/{mygroupid}/datasets

but if I try and see the tables in a specific group using

https://api.PowerBI.com/v1.0/myorg/groups/{mygroupid}/datasets/{mydatasetid}/tables

I get a 501 error : "The remote server returned an error: (501) Not Implemented."

According to this documentation updated in Feb https://msdn.microsoft.com/en-us/library/mt203556.aspx it should work.

Is this method working for other people?

Cheers,

Phil

Re: Using Rest API to List Tables Group

Phil_Seamark — Thu, 21 Jul 2016 20:47:59 GMT

Further to this, when I try to list tables under a dataset in My Workspace I get "GET tables method is not supported for this dataset" even using the Apiary API console.

Does the API only work with certain kinds of Datasets?

Re: Using Rest API to List Tables Group

Phil_Seamark — Sun, 24 Jul 2016 21:50:29 GMT

I have since found that if I create the dataset using the API, I can list tables in the dataset (regardless of if in a shared workspace or not).

However my problem was when I created a table in Power BI Desktop and then published to the Service. I can't list these tables.

So I have adjusted my code to create the dataset & table using the API and I can stream data into it.

Re: Using Rest API to List Tables Group

leovillarroel — Thu, 05 Apr 2018 19:37:28 GMT

HI Phil:

I'm trying to get the app produced in a workspace and the users that has been granted access to it. Tried with rest get method:

$uri = "https://api.powerbi.com/v1.0/myorg/groups/$($group.id)/applications"

$uri = "https://api.powerbi.com/v1.0/myorg/groups/$($group.id)/apps"

Bur i'm getting

Invoke-RestMethod : The remote server returned an error: (404) Not Found.

Do you happen to know if there's a way to get the infor I'm trying to pull?

Many thanks in advance.

Leo.