Forum Discussion

anoomohan's avatar
anoomohan
Icon for Helper III rankHelper III
2 years ago

Data refresh from excel to Powerbi Service

Hi all,

 

After publishing the dataset and report from desktop to service, i want to refresh some data; 

 

I already created link from my excel source file to PBI service, but after updating data in excel the report in PowerBi service is not getting updated (after refresh) , but report in desktop is getting updated after refresh

 

Does it mean I need to republish again - after each data update in excel?

Need Help

3 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    2 years ago

    hI anoomohan ,

    Is your Excel file stored in Sharepoint and you're using the web url instead of the local path or is it stored locally in your device? If the latter, then you'll need to use a data gateway that will serve as a bridge between your device and Power BI service.

  • christinepayton's avatar
    christinepayton
    Icon for Most Valuable Professional rankMost Valuable Professional
    2 years ago

    If you make any changes in the desktop app, you need to republish to have them be reflected in the web app / scheduled refresh, yes. 🙂

  • anoomohan's avatar
    anoomohan
    Icon for Helper III rankHelper III
    2 years ago

    Thanks, on another point, once published and if all are ok, is it ok if the desktop file is deleted by mistake? 

     

    the pbi service automatically picks up data from excel and we dont need desktop file anymore right - unless we need to do some changes in the measures or row level security?