Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hi @HOOPI ,
Has the problem be solved?
Best Regards,
Jay
Hi Jay,
Not yet, actually. I'm open for advice! 🙂
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!
@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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |