How to automatically update dataset

[HOOPI]

Hi Everyone. 

Im experiencing some difficulties regarding update of datasets. 

The case is:

I have an excel-sheet stored on my laptop. 

I made a report in POWER BI Desktop

I Published the report to my companies website (this part works).

I have successfully gotten power BI to automatically update from published report down to power BI desktop. 

But how do i make power BI Desktop automatically update changes in the excel-sheet - if even possible?

PLEASE HELP! Im stuck 😞 

Kind Regards

Holger Nielsen

[v-jayw-msft]

Hi @HOOPI ,

Has the problem be solved?

Best Regards,

Jay

[HOOPI]

Hi Jay, 

Not yet, actually. I'm open for advice! 🙂

[HOOPI]

Thanks a lot! I will try this, and see if it solves my problem. If yes, I'll make sure to accept as solution. Thanks!

[amitchandak]

@HOOPI , You need to use a on-premise gateway and schedule refresh.

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

Better to have file on onedrive or sharepoint

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive

Gateway - if needed

https://radacad.com/the-power-bi-gateway-all-you-need-to-know
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot