Forum Discussion

B_Raines's avatar
B_Raines
Regular Visitor
1 year ago
Solved

Access OneDrive Refresh Location via API

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...
  • V-yubandi-msft's avatar
    1 year ago

    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.