Blank Values API Output for the Dataset Refreshes

[olegkazanskyi]

Hello.

I use the API request to get the latest refresh date for the available datasets.

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

It works well for the majority of cases but for some datasets, it returns "" even it was refreshed not a long time ago.

Does anyone know how to fix this?

[olegkazanskyi · Accepted solution]

We identified that we get blank values for the datasets that users upload to the Service from time to time and do not use the "refresh" button.

[collinq]

Hi @olegkazanskyi ,

I would triple check the dataset id.  It would appear to me that you are getting a "null" because there is nothing being grabbed by the API.  

OR - do you have the permissions to see that dataset (or the userid that you are using the API with)?

[olegkazanskyi]

Hi @collinq ,

Yes, the account has an admin access level to the workspace.

I've double-checked the dataset_id and it is correct. It was retrieved from another scanning script.

[collinq]

Hey @olegkazanskyi ,

Does the status show "Failed" or "Completed" when it is null?

[olegkazanskyi]

Hello @collinq , 

shows complete- 200

[collinq]

Hi @olegkazanskyi ,

This sounds quite unusual.  I think that because this is something that Microsoft can see that we can't I would turn in a ticket and have Microsoft find what they see on their side.