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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

I built the report in PBI Desktop, published it to the service. I've created dashboards off of that. I need all of that to refresh on a regular basis without me having to open up the PBI Desktop file and click "refresh" and then click "publish".

  • 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