Forum Discussion

SW23's avatar
SW23
New Member
3 years ago
Solved

Analyze in Excel not working for certain users

Hi, I have a report published in a premium capacity workspace. I have Power BI Pro License. I shared this report with other users who have a free license. Some of them can Analyze in Excel, howeve...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi SW23 ,

     

    Based on this document: Power BI Analyze in 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: Initialization of data source failed

    His issue is caused due to the too old version of Excel.

     

    Could you please check if reach the requirement and limitations in this document.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi SW23 ,

 

Based on this document: Power BI Analyze in 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: Initialization of data source failed

His issue is caused due to the too old version of Excel.

 

Could you please check if reach the requirement and limitations in this document.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • SW23's avatar
    SW23
    New Member
    3 years ago

    Thanks for the reply and all the documentation links. Installed the updates for Analyze in Excel, and now the user is able to perform the function.