Forum Discussion
ACCESS TO POWER BI ONLINE DATABASE CONNECTION
Hello!
I'm having issues to get my data updated from access.
The database is correctly connected through "web" with a sharepoint link, I did this on PBI desktop.
The issue comes when I configure&schedule the auto-update, it simply doesn't work.
I'm working with 64 bit version in office,access and PBI, also downloaded this...Microsoft Access Database Engine 2016 Redistributable
and still doesn't work.
if anyone can help...or find an alternative, thks
No, XLS files have the exact same issue. Use XLSX or better CSV.
3 Replies
- lbendlin
Super User
Don't use Access, it is not worth all the hassle (especially the contortions you need to do on the gateways). Move your data source to a SQL Server database.
Thanks for you reply! If I'm not able to use SQL...alternative would be using xls files?
- lbendlin
No, XLS files have the exact same issue. Use XLSX or better CSV.
