Access OneDrive Refresh Location via API

[B_Raines]

There was recently the addition of the source location for OneDrive refresh on a semantic model. This is a game changer when supporting a large number of report builders in a large organisation. 
Is there, or will there be, the ability to access this information via either the Power BI or Fabric REST APIs?

[V-yubandi-msft]

Hi @B_Raines .,

We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.

Your feedback is valuable to us, and we look forward to hearing from you soon.

Thanks...

[V-yubandi-msft]

Hi @B_Raines ,

Has your issue been resolved, or do you require any further information? Your feedback is valuable to us. If the solution was effective, please mark it as 'Accepted Solution' to assist other community members experiencing the same issue.

[V-yubandi-msft]

Hi @B_Raines ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank You.

[V-yubandi-msft · Accepted solution]

Hi @B_Raines ,

Thank you for reaching out to the Microsoft Fabric Community.

With the recent inclusion of the source location for OneDrive refresh on a semantic model, managing and supporting numerous report builders has become significantly easier. However, I would like to confirm if this information is currently accessible via the Power BI REST API or Fabric REST API.

1. At present, there is no specific API that directly provides the OneDrive source location for a semantic model refresh. This limitation has been highlighted in the community, and many users would find such an API feature beneficial.

Nevertheless, there are existing API endpoints that offer partial information.

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

This API retrieves data source details for a specified dataset. It provides connection information but does not clearly indicate if the dataset is refreshed from OneDrive.

Microsoft Docs: Get Datasources

2️. Get Refresh History API - This API enables tracking the refresh history of a dataset, offering insights into previous refresh operations. However, it does not indicate whether the refresh was performed via OneDrive.

FYI:

Microsoft Docs: Get Refresh History

Helpful Reference: Solved: Rest API OneDrive Refresh History - Microsoft Fabric Community

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.