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 shared a report, when the user is exporting the data using analyze in excel, user is getting the error..
Initialization of the data source failed.
Check the database server or contact your database administrator, Make sure the external database is available, and then try the operation again. If you see this message again, create a new data source to connect to the database.
User has excel 2010
Solved! Go to Solution.
Hi @Anonymous ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The user was using excel 2010, and that's the culprit, they have to upgrade the excel version , to 2016.
Hi @Anonymous ,
Based on this document: https://exceleratorbi.com.au/power-bi-analyze-excel-what-you-need-to-know/
This issue is related to you not having the correct data connector installed for your version of Excel. Make sure you have installed the correct (64 bit or 32 bit) data connector as covered earlier in this documents like following
Please also refer to the similar thread: https://community.powerbi.com/t5/Service/Analyze-in-Excel-Initialization-of-the-data-source-failed/td-p/24928
Could you please check if reach the limitations in this document: https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel#requirements
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
In our company, we have the same problem when sharing Excel - files with connection to PowerBI dataset. So the data refresh in Excel is no problem, also with the desktop version of Excel for the user who made the connection but not for other users.
Can it be that the version of Excel is a problem? The pro users who make te report have 64bit versions of Excel, the readers 32 bits.
Thank you for your reply!
Kind regards,
Steven
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.