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 a dashboard connected to variety of dynamic data sources (XLS and XLSX from multiple websites). It refreshes fine in PBI Desktop but not in PBI Service.
I receive this error message when refreshing in PBI Service:
I have installed "AccessDatabaseEngine_X64" on my machine as both PBI Desktop and Office 365 are 64 bit but PBI Service still gives me the error message with every auto refresh attempt.
Have no problem with XLSX sources and it's only XLS sources are causing this issue in PBI Service. I know re-saving XLS sources in XLSX format will resolve this issue but XLS sources are coming dynamically from multiple web sources and I don't want making them static sources if re-saving in XLSX format.
Any thoughts or solution please?
Thank you.
Use Power Automate or another tool to convert the XLS to XLSX when they arrive.
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.