User not able to use Analze In Excel

Hi nitishsh91 ,

You may see this error "Initialization of the data source failed", particularly the first time you try to do this. This is normally related to you not having the correct data connector installed for your version of Excel. Make sure your users have installed the correct (64 bit or 32 bit) data connector on their own computers.

Reference: Power BI Analyze in Excel – What You Need to Know 

In addtional, you could check if reach the limitations in this document: https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel#requirements

• Analyze in Excel is supported for Microsoft Excel 2010 SP1 and later.
• Analyze in Excel requires that the dataset be in Power BI Premium or that the user have a Power BI Pro license.
• Users can connect to datasets through Analyze in Excel if they have read permission on the underlying dataset. 
• The Analyze in Excel is a Power BI service feature, and is not available in Power BI Report Server or Power BI Embedded.
• Analyze in Excel is only supported on machines running Microsoft Windows.
• Some organizations may have Group Policy rules that prevent installing the required Analyze in Excel updates to Excel.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.