8 Replies Latest reply on Sep 24, 2014 8:32 AM by Rajdeep Panchal

    MS Access datasource - how to refresh automatically

    Rajdeep Panchal

      Hello,

       

      Here is my case, and need help.

       

      Database - MS Access 2010

       

      I created a dashboard using Access data, extracted data (TDE) created TWBX and published it - TWBX is published.

       

      I want to find out how to achive this

       

      Every day morning, I want to update TWBX from server - that means without republishing the workbook.

       

      I do not know how to embedded MS Access credentials. Because the MS access file is on a shared network.

       

      Can someone guide me how to take care of this use case?

       

      Technically this is what i want to achieve --

       

      Once i publish TWBX on server, I see there is an option called - "Scheduled Tasks", once you click it, it gives 2nd screen, which has another option called "Add Full Refresh" - if you click that, you will see multiple options including - "Run Now" - I want to findout how to enable this

       

      Means, if I have created TWBX using MS Access, where I have extracted data and published it on server - how will Tableau update data if i click on "Run Now"

       

      How do i add file path so Tableau knows what to look for?

       

      Thaks for reading and please help....