How to refresh a published report

[oliviaccc]

Hello all,

I am new to the PBI. I've created a report in Power BI Desktop and have published it to My Workspace within the Power BI Service. At present, my process for updating the report involves manually clicking "refresh" in Desktop and republishing it to the service. I'm curious to know if refresh the semantic model by clicking "refresh" button directly in My Workspace can also work. My data are 2 excel files, one is on sharepoint and one is in my local machine.

Additionally, I discovered that reports can be edited in My Workspace. If I make changes there, will those changes sync and update my original Desktop file?

Thank you so much.

[christinepayton]

The easiest way to do this is to upload the Excel files to SharePoint Online if you have it available, then swap out the path that the query is referencing to SharePoint. That will let you schedule refresh on it or refresh in the web service. I've got a tutorial link I can dig up if that sounds like it would help-- 

[Idrissshatila]

Hello @oliviaccc ,

you need to set a gateway that will read from the excel in your on prem source.

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install

regarding this question that you mentioned "If I make changes there, will those changes sync and update my original Desktop file?",

the answer is no, if you want the changes you made in service to be in desktop then you need to download the edited version in power bi service .

[mohitkumawat]

Hi @oliviaccc ,

Please check the below blog for the Refresh Power BI Semantic Model.
https://support.tygraph.com/support/solutions/articles/67000173328-how-to-refresh-a-power-bi-dataset