Can't get datasets info

[weiyu_chen]

Hi there,

When I run the following in Postman:

GET https://api.powerbi.com/v1.0/myorg/datasets

I got the following in response:

{

"@odata.context": "http://wabi-canada-central-redirect.analysis.windows.net/v1.0/myorg/$metadata#datasets",

"value": []

}

There is no info on datasets' id and name, etc as in the doc: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/get-datasets

Could you please tell me what's wrong there?

Thanks!

PS:

If I run 

GET https://api.powerbi.com/v1.0/myorg/datasets/{dataset_id} 

I can get all the info I need. I just need to get all the metadata in My Power BI API.

[HaoZhan · Accepted solution]

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_chen]

Thanks a lot for the reply. I will check this out.

Best regards,

Weiyu

[Anonymous]

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_chen]

@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

[Anonymous]

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

[weiyu_chen]

Hi @Anonymous Thanks for the reply. I don't know what's the guide report. I didn't create any report, just connected to Sales Analytics for Dynamics 365 Sales and other Dynamics' datasets. Do you have any links on permission issues?

Thanks a lot,

Weiyu

[Anonymous]

Hi @weiyu_chen,

So you mean you are working with the template connector on the power bi service side? Have you tested to remove these specific contents from your workspace and try again?

Regards,

Xiaoxin Sheng

[weiyu_chen]

Hi @Anonymous,

No, I didn't try that, which one do you think is specific, I should remote. Indeed, the purpose of my test is using Power BI to access Dynamics' entities. 

Thanks!

Weiyu

[Greg_Deckler]

@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_chen]

Hi Greg,

Thanks for the reply. I have tried `Try It`, get the same result as in postman:

Thanks,

Weiyu

[Greg_Deckler]

@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".

[weiyu_chen]

@Greg_Deckler Thanks a lot. I will create a support ticket.