I am currently using flat files (Excel, .csv) stored in One Drive as the basis for my dashboards. Each day I replace the dataset and manually "refresh" and "Publish" to update these dashboards.
I am looking for some tips or direction to schedule these refreshes, and automating the "Refresh" and "Publish" process.
Within the Datasets area of the dashboard, I get the following message:
Beyond this, I am bot given an opportunity to Edit the credentials to schedule the Refresh process.
Looking for any information or best practices to automate this process.
Thanks in advance.
How did you go about connecting to those OneDrive files, did you do that through the Desktop or through the Service. I assume Desktop since that is the forum you posted in but want to confirm.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
