How to automatically update dataset

Question

Hi Everyone.&nbsp;&nbsp;Im experiencing some difficulties regarding update of datasets.&nbsp;The case is:&nbsp;I have an excel-sheet stored on my laptop.&nbsp;I made a report in POWER BI DesktopI Published the report to my companies website (this part works).&nbsp;I have successfully gotten power BI to automatically update from published report down to power BI desktop.&nbsp;But how do i make power BI Desktop automatically update changes in the excel-sheet - if even possible?&nbsp;PLEASE HELP! Im stuck 😞&nbsp;&nbsp;Kind RegardsHolger Nielsen

amitchandak · Answer

Anonymous , You need to use a on-premise gateway and schedule refresh.
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
&nbsp;
Better to have file on onedrive or sharepoint
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive
&nbsp;
&nbsp;
Gateway - if needed
https://radacad.com/the-power-bi-gateway-all-you-need-to-knowhttps://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onpremhttps://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot

anonymous · Answer

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!&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Has the problem be solved?
&nbsp;
Best Regards,
Jay

anonymous · Answer

Hi Jay,&nbsp;&nbsp;Not yet, actually. I'm open for advice! 🙂

Forum Discussion

How to automatically update dataset

4 Replies

Related content

Year updated automatically

Onedrive automatic update does not work

How to update shared expression automatically?

Automatics Refresh

Automatically update app