topic Re: Get- Refresh History from OneDrive Source in Developer

Get- Refresh History from OneDrive Source

paololito — Fri, 28 Apr 2023 09:53:35 GMT

Hello,

My purpose is to extract the refresh history of all datasets with the Rest API "get-refresh-history-in-group" but the Microsoft documentation inform that it's not possible if the source is located in OneDrive .

I contacted the Microsoft support but they said that it's an actual limitation so they didn't provide me an alternative solution .

Can you please help me on this ? Does some of you have already be face of this problem ?

Thanks a lot for your Help

Re: Get- Refresh History from OneDrive Source

lbendlin — Tue, 02 May 2023 01:28:06 GMT

Use the Tenant Audit log reports to capture all dataset refresh requests.

Re: Get- Refresh History from OneDrive Source

paololito — Mon, 08 May 2023 09:39:14 GMT

Do you know what activity name I need to export in the Audit log ? my purpose is to have the last refresh of all datasets

Re: Get- Refresh History from OneDrive Source

lbendlin — Mon, 08 May 2023 13:25:05 GMT

Audit_RefreshDataset

gives you (among others) RefreshType and DataConnectivityMode.

However - they are right in saying that this does not capture OneDrive refreshes.

Re: Get- Refresh History from OneDrive Source

paololito — Mon, 08 May 2023 14:23:45 GMT

Sorry but I don't see any activity names called Audit_RefreshDataset, Are you in Microsoft Pureview to have this activty in the list ?

Re: Get- Refresh History from OneDrive Source

paololito — Mon, 08 May 2023 14:53:07 GMT

Just to explain the context , I need to do some cleaning in Power bi environment as there are a lot of unusable reports and datasets . I understand that all datasets refreshed from OneDrive Source can not be extracted to a report . Do you have an alternative to extract the information's requested ?

Re: Get- Refresh History from OneDrive Source

lbendlin — Mon, 08 May 2023 16:42:26 GMT

I need to do some cleaning in Power bi environment as there are a lot of unusable reports and datasets

those things are not necessarily correlated. What's your actual issue? Are you running out of capacity space?

Re: Get- Refresh History from OneDrive Source

paololito — Tue, 09 May 2023 06:42:56 GMT

In fact I need to report all objects to facilitate the migration between Tenant .