Forum Discussion

rosa_pch's avatar
rosa_pch
Regular Visitor
1 year ago
Solved

MS Access Data Source in SharePoint Refresh Not Working

I set up a data source connection to a SharePoint folder in Power BI Desktop that loads tables from a Microsoft Access Database stored in that SharedPoint folder. After i publish the dashboard to the...
Dataflow
  • SaiTejaTalasila's avatar
    SaiTejaTalasila
    1 year ago

    Hi rosa_pch ,

     

    Follow this steps -

    Keep your .accdb file in your computer/VDI and install power bi gateway(personal mode). Next, you need to republish your report. I'm pretty sure it will work as I already helped 2 users at our tenant.

     

    I hope this helps.

     

    Thanks,

    Sai Teja 

v-sgandrathi's avatar
v-sgandrathi
Community Support
1 year ago

Hi rosa_pch,

Thank you for reaching out to Microsoft Fabric Community Forum.

Power BI Service does not support Microsoft Access database files, especially when stored in SharePoint, due to the absence of the required Access Database Engine.
To resolve this, we recommend moving the data from Access to a supported format such as Excel (stored in SharePoint or OneDrive), SQL Server, or SharePoint Lists. Once migrated, update your Power BI report to connect to the new source, publish it, and configure a scheduled refresh.
If using an on-premises SQL Server, please ensure a data gateway is set up for seamless refresh.

 

If my response was helpful, consider clicking "Accept as Solution" and give us "Kudos" so that other community members can find it easily. Let me know if you need any more assistance!

 

Thank you,

Sahasra

Community Support Team.

v-sgandrathi's avatar
v-sgandrathi
Community Support
1 year ago

Hi  rosa_pch,

 

We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

If my answer resolved your query, please mark it as "Accept Answer" and give Kudos if it was helpful.

If you need any further assistance, feel free to reach out.

Thank you for being a valued member of the Microsoft Fabric Community Forum!