Forum Discussion
Microsoft EmployeeUsing Rest API to List Tables Group
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
3 Replies
- Phil_Seamark
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?
- Phil_Seamark
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.
leovillarroelAdvocate I
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.
