Forum Discussion

WayneH_04's avatar
WayneH_04
Frequent Visitor
4 years ago
Solved

Failed Refresh of Dataset Error

I have a pbix file and the datasources (one of which being an access database) are connected to a private sharepoint site.   I have published the report up to Power BI service.   When I try to re...
Need Help
  • Burningsuit's avatar
    Burningsuit
    4 years ago

    Hi WayneH_04 

    As you say, it is the Access database causing this problem. It is not possible to schedule refresh an Access data source unless you use a Personal Gateway. You'll need to install a Personal Gateway on the machine you installed the access database engine, and route the refresh through there.

    see : Use personal gateways in Power BI - Power BI | Microsoft Docs

    Hope this helps

    Stuart

Burningsuit's avatar
Burningsuit
Icon for Resident Rockstar rankResident Rockstar
4 years ago

Hi WayneH_04 

As you say, it is the Access database causing this problem. It is not possible to schedule refresh an Access data source unless you use a Personal Gateway. You'll need to install a Personal Gateway on the machine you installed the access database engine, and route the refresh through there.

see : Use personal gateways in Power BI - Power BI | Microsoft Docs

Hope this helps

Stuart