Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
Short version:
How can I schedule and make sure that my excel sheet with auto update keeps on updating daily?
Longer version:
I am having some issues with using Power Query in Excel. In particular, with the use of OData from Azure Devops, and with auto refreshes:
For reference, here is the config I have on my connections:
Thanks in advance for any help,
Jens
Hi @JensEilertsen ,
According to your description, first of all, you mentioned to set up timed refresh for the data source, if you want to refresh according to once a day or twice a day, you can set it to refresh every 1440 minutes or 720 minutes. Also to make sure the refresh doesn't get locked you need to enable the background refresh option.
Regarding authentication, you can delete your original credentials in the data source settings in Get Data and reconfigure the credentials using another authentication method. It's not possible to determine what your error message is, so you can check the following documentation to correspond to your error message
Power Query OData Feed connector - Power Query | Microsoft Learn
Authentication in desktop apps - Power Query | Microsoft Learn
Handling authentication for Power Query connectors - Power Query | Microsoft Learn
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi,
Thanks for the response. The screenshot I added at the bottom is in Norwegian, but "Aktiver bakgrunnsoppdatering" is enabling backgroun refresh and "Oppdater hvert 720 minutt" means it is set to updating every 720 minutes as per your suggestion. However, no updates occur even when I am gone for the document for 24 hours regardless if I have the excel file open or not.
As for the point of the exact error message, I will try to reproduce it, but it does usually work, it is just after a few days it seems like it bugs out.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
67 | |
61 | |
23 | |
17 | |
12 |