Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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 ?
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?
In fact I need to report all objects to facilitate the migration between Tenant .
Sorry but I don't see any activity names called Audit_RefreshDataset, Are you in Microsoft Pureview to have this activty in the list ?
Use the Tenant Audit log reports to capture all dataset refresh requests.
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
Audit_RefreshDataset
gives you (among others) RefreshType and DataConnectivityMode.
However - they are right in saying that this does not capture OneDrive refreshes.
User | Count |
---|---|
5 | |
5 | |
3 | |
2 | |
2 |
User | Count |
---|---|
9 | |
7 | |
4 | |
4 | |
4 |