Forum Discussion

Baseley09's avatar
Baseley09
New Member
3 months ago
Solved

PowerBI no longer able to reference Access database

Hi all, since the 14th of this month our PowerPI report has been unable to connect to our Access database ( this sits on a local server) , the error states: The database you are trying to open requir...
Data Protection
  • oussamahaimoud's avatar
    oussamahaimoud
    3 months ago

    So you should try this now :

     

    Step 1: Find the actual gateway machine

    Go to Power BI Service:

    Settings → Manage connections and gateways

    Find the gateway associated with this dataset

    Note the machine name listed under that gateway

    That is the machine where you need to install the 64-bit Access Database Engine.

     

    Step 2: Check which gateway the dataset is using

    Go to your Workspace → Datasets → (the failing dataset) → Settings

    Expand Gateway and cloud connections

    It will show you exactly which gateway cluster is mapped

     

    Step 3: Go to THAT machine and:

    Install the 64-bit Access Database Engine 2016 (/quiet if Office C2R blocks it)

    Confirm the "On-premises data gateway service" IS present and running

    Restart that service

     

    If no gateway shows as mapped, it's possible the gateway was uninstalled or the service crashed around May 14th, which would perfectly explain why refreshes suddenly stopped on that date. In that case the gateway would need to be reinstalled on the correct server from: https://aka.ms/opdg

v-anbandari's avatar
v-anbandari
Icon for Community Support rankCommunity Support
3 months ago

Hi  Baseley09 ,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to oussamahaimoud sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

 

Thank you for being part of the Microsoft Fabric Community.