Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Automated refresh excel from network path data in power BI

Automated refresh excel from network path data in power BI

 

I have reading excel from network path. If i change excel data, BU report should refresh. How can i achieve this in Power BI. Do we have extract refresh?

 

I am new to power BI

Need Help
  • adityavighne's avatar
    adityavighne
    6 years ago

    Anonymous 

     

    1) your excel sheet is in the Network folder just copy that path or connect in Power BI desktop.

    2) With SQL no need to do anything it will auto fetch your login credentials

    3) Publish your report to power bi service and schedule refresh time 

7 Replies

  • adityavighne's avatar
    adityavighne
    Icon for Continued Contributor rankContinued Contributor
    6 years ago

    Anonymous 

     

    connect to network path excel sheet and schedule a refresh time in Power BI service.

     

    regards,

    Aditya

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Do you have any reference link for this i am new to PowerBI

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Dear Anonymous 

         

        You can refresh the data in 2 ways 

        Power BI desktop: Whenever excel is updated with the data then refresh the report/dashboard and publish in the Service/Cloud

        Power BI Service: you can schedule the auto refresh by creating the gateway with the network path then the updated data will be displayed in the dashboard.

         

        You can find the details in the following path

        https://docs.microsoft.com/en-us/power-bi/refresh-data 

         

         

         

        Regards, 

         

        Munna