Forum Discussion
Can't get datasets info
Hi there,
When I run the following in Postman:
GET https://api.powerbi.com/v1.0/myorg/datasets
I got the following in response:
Hi, I have the same problem.
In the end, I found that all these datasets are not under 'myspace' but a 'groupspace'.
Maybe, you can check it.
If you want to get the datasets under the group, you need to get the groupId first, and use this API
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/get-datasets-in-group#code-try-0
GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets
12 Replies
- Greg_DecklerCommunity Champion
weiyu_chen Maybe something up with permissions? Use the Try it feature here: Datasets - Get Datasets - REST API (Power BI Power BI REST APIs) | Microsoft Docs.
Worked for me. Also, this worked in Powershell:
Invoke-PowerBIRestMethod -Url 'datasets' -Method Get
- weiyu_chenFrequent Visitor
Hi Greg,
Thanks for the reply. I have tried `Try It`, get the same result as in postman:
Thanks,
Weiyu
- Greg_DecklerCommunity Champion
weiyu_chen You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
- AnonymousNot applicable
Hi weiyu_chen,
Have you added any specific datasets to your workspace? I test on my side and this API works well.
Please share more detailed information to help us clarify your scenario and test to troubleshoot:
How to Get Your Question Answered Quickly
Regards
Xiaoxin Sheng
- weiyu_chenFrequent Visitor
Anonymous Thanks for the reply. Yes, we have 7 datasets in the workspaces, 6 of them are Dynamics 365 related, 1 is from the How-to guides (https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quickstart-learn-dax-basics), that's the Contoso Sales Sample for Power BI Desktop file. As you can see in the following sreenshot:
Thanks,
Weiyu
- AnonymousNot applicable
Hi weiyu_chen,
I suppose this issue may relate to that report(power bi rest api not has corresponded permissions to process on the guide report), perhaps you can try to remove that report and try again.
Regards,
Xiaoxin Sheng
- HaoZhanNew Member
Hi, I have the same problem.
In the end, I found that all these datasets are not under 'myspace' but a 'groupspace'.
Maybe, you can check it.
If you want to get the datasets under the group, you need to get the groupId first, and use this API
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/get-datasets-in-group#code-try-0
GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets
- weiyu_chenFrequent Visitor
Thanks a lot for the reply. I will check this out.
Best regards,
Weiyu