Forum Discussion
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...
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
So...you have an Access database in SharePoint Online?