Forum Discussion

viswaaa's avatar
viswaaa
Icon for Helper IV rankHelper IV
1 year ago
Solved

Shared drive data refresh

Hi All,   I have a excel located in my share drive and every day it will update by the user. I need to get the updated data every day from this file to my report.   Could any one please suggest ...
Need Help
  • HarishKM's avatar
    HarishKM
    1 year ago

    viswaaa 
    Hey,
    1) You can move that file to one of your teams page folder on share point or one drive

    2) you can use the same link to create connection on power bi desktop using Sharepoint or one drive connector.

    3) once done then you can use publish your report to power bi service.

    4) for sharepoint, You do not require a gateway to refresh so you can directly setup refresh as per your requirement.

     

    Thanks

    Harish KM

    Please accept this as a solution if this solves your problem and give kudos as well.

     

ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
1 year ago

This Excel file is located on a File Server? And you have a published Power BI Report deployed to a Workspace, with maybe the App published?

You will need to install a Gateway (please do not use the Personal mode) on a server in the farm. It must have access to the File Share. Then set up a File (type) Data Connection using the Gateway, and specify that file. You should design the Power BI report so that the path to the file is the same relative path as would it would be via Data Connection.

Then set up a refresh schedule for the Powr BI model