Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Access Database On-Prem Enterprise Gateway

We are using the enterprise gateway, but I am having trouble getting an MS Access DB added. I need to have it refresh on a scheduled basis. What is the best way to get an MS Access DB to refresh on a...
Need Help
zoloturu's avatar
zoloturu
Icon for Memorable Member rankMemorable Member
8 years ago

Anonymous,

 

Go to your workspace -> Datasets -> Find dataset related to your report -> Press Schedule refresh -> Go to Scheduled Refresh and set time and frequency

Anonymous's avatar
Anonymous
Not applicable
8 years ago

We have an on-prem enterprise gateway installed, but I do not have a personal gateway installed. I need instructions for my IT guy to add the access databse to the gateway. He was able to add sharepoint, but it doesn't appear that it will support ms access.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Anonymous,

     

    Access database is a file, I'd like to suggest you add new datasource with 'file' type. 

    Access Database in Power BI Online  

     

    Regards,
    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Yes I've done that in the PBI Desktop file, but how do I get this to refresh without manually refreshing the file and then clicking publish, without a personal gateway?

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Anonymous,

         

        Nope, current it seems like only allow with personal gateway.

         

        Regards,

        Xiaoxin Sheng