Forum Discussion

pkoetzing's avatar
pkoetzing
Advocate III
9 years ago
Solved

PBI Service refresh from MSAccess on SharePoint?

Hi,   My dataset is connected to a MSAccess database on SharePoint. Refreshing from PBI Desktop works fine, but refreshing from PBI Service fails with the following message:   Microsoft Access: T...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    pkoetzing,

    I export a Access table to sharepoint list via "Extenal data"->"More"->"SharePoint list" option in Access, after that I connect to the list using "SharePoint Online list" entry in Power BI Desktop, create report and publish report to Service.

    This way, I click "Refresh Now" in Power BI Service to refresh the dataset, everything works well. Could you please perform the above steps in your scenario and check if it is successful?

    Regards,
    Lydia

chaz2jerry's avatar
chaz2jerry
Advocate IV
6 years ago

Having similar issue and cannot connect from PowerBI dataflow (service) to the Access DB file on Sharepoint, even after installing Access 64bit driver on an enterprise gateway and applying the gateway in the dataflow.

 

Current workaround is to connect dataflow to the same Access DB file on a network drive, through the gateway (with Acces 64bit driver installed).

NSRjecross's avatar
NSRjecross
Frequent Visitor
6 years ago

chaz2jerry  I realiased this was a very old thread, marked as resolved (because they had a workaround for the original poster).

I started a discussion https://community.powerbi.com/t5/Power-Query/reading-access-databases-hosted-in-sharepoint-libraries-works-in/td-p/1210650/jump-to/first-unread-message to focus on connecting to the files as-is rather than having to ETL out to somewhere else first.

I'm curious how you managed to route your sharepoint connection via the on-premise gateway though. Our gateway couldn't support Oauth2 for sharepoint even last week. (just had the option pop up for us during testing this morning!)  See you on the other thread!