Data refresh from excel to Powerbi Service

[anoomohan]

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?

[anoomohan]

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? 

[christinepayton]

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. 🙂

[danextian]

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.