Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have 3 sources, a folder with Excel files that are combined in Power Query, a separate Excel file and an Access database but they're Excel and Access files. All files have either *.xlsx or *.accdb. Both are Office 365 64bits. I created my Power Bi desktop file and works ok but when I publish it on a Sharepoint site, and I try refreshing the dataset, I get this error.
I've tried installing both versions of the Microsoft Access Database Engine 2010 and 2016 and still get the same error. If I try to publish the Access database as a list on the Sharepoint site, it would take a lot of time since it's updated daily and as of today, it has aproximately 500k registers. All the Excel files in the folder are deleted after 7 days and are replaced with new ones.
@LuisPedro , refer if this can help
https://exceleratorbi.com.au/64-bit-power-bi-desktop-32-bit-office-can-do/
@amitchandak Thanks for the reply,
I have both 64 bits installed. After reading the link you posted, it says that If I install de 32 bits, It would work?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |