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 

Cookistador's avatar
Cookistador
Super User
1 year ago

It is not possible to fix this issue

You could not use an access database in SharePoint with Power BI

I have this use case a few months ago, and I found some posts from microsoft saying that it was not supported

 

I created a flow with ssis to write the data from access to a sql database