Forum Discussion

5 Replies

  • hnam_2006's avatar
    hnam_2006
    Frequent Visitor

    Hi HERNAN17 

     

    I think the excel file may need to be reconnected. 

    Go to "transform data" --> "data source setting". Check the connection or rebuild the connection. 

     

    If you are using SharePoint, i suggest you go to the file location and select the file (dont open it). When you select the file, you can see a "details" pane open. In here, there is a path. Copy that and go to powerBI. In data source, replace the excel path with this SharePoint path and you can ensure file is updated even when your laptop/desktop is switched off. Ofcourse, you need to schedule refresh in PowerBI service

    refer to the youtube vide for more details: How to get a file path to a file in SharePoint Online 

     

    Best Regards,

    hnam_2006

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

  • v-sdhruv's avatar
    v-sdhruv
    Icon for Community Support rankCommunity Support

    Hi HERNAN17   ,
    Just wanted to check if you had the opportunity to review the suggestion provided?
    If the response has addressed your query, please accept it as a solution  so other members can easily find it.
    Thank You

  • v-sdhruv's avatar
    v-sdhruv
    Icon for Community Support rankCommunity Support

    Hi @HERNAN17   ,
    Just wanted to check if you had the opportunity to review the suggestion provided?
    If the response has addressed your query, please accept it as a solution  so other members can easily find it.
    Thank You

  • v-sdhruv's avatar
    v-sdhruv
    Icon for Community Support rankCommunity Support

    Hi @HERNAN17   ,
    Just wanted to check if you had the opportunity to review the suggestion provided?
    If the response has addressed your query, please accept it as a solution  so other members can easily find it.
    Thank You