I'm working on OneDrive report on PowerBI Desktop. I've read only access to sharepoint server. And I'm searching for user information regarding last sync or age of last sync (Syncing details on OneDrive). I'm unable to find in database. Let me know if someone has knowledge about it.
You want to report users' synchronization information on OneDrive in Power BI desktop, right? Per my knowledge, there is no direct data connector to fetch such information in desktop, you may try to export this information to files like excel, csv and so on. Or if this information is stored in database, you can directly connect to database from desktop. For where to find the information in Onedrive, this is a question related to Onedrive, please post thread on OneDrive forum for support.
Community Support Team _ Yuliana Gu If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.