Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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
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?
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
5 | |
3 | |
2 |