Forum Discussion

sbroaden's avatar
sbroaden
Helper I
9 years ago

Error analyzing in excel: Connection failed because user credentials are needed...

I have some users that are unable to analyze in excel.  They have downloaded the latest Excel updates from Power BI and also have OLE db providers for 2016, 2014, 2012 as well.  As far as I can tell ...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi sbroaden,

 

Based on my research, I see the same error can be caused by the AS OLEDB provider isn't current. I would suggest you double check it follow this article. Then you can try to restart the computer to test again.

 

If issue persists, please use Fiddler to capture the trace, share .saz file with us.

 

Best Regards,
QiuyunYu

sbroaden's avatar
sbroaden
Helper I
9 years ago

v-qiuyu-msft Thanks. I wasn't able to get anywhere with the link you had...can you repost?  Also, do you know if it's the most current 2016 AS OLE DB that you download from powerbi.com?  In the Analyze in Excel updates?  Do you know how often they update those as we will have to make sure we re-package and re-push those updates to all users.  I had thought 2016 would only have one version but it seems we need to update more frequently and I am having a hard time knowing HOW frequent.  Our users cannot download on their own so they all start getting errors.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi sbroaden,

     

    The link I want to share in my previous post is this.

     

    You can see IlanH's post here, the link provided in download section points to the most recent AS OLEDB provider, it will detect current installed AS OLEDB provider to check if you need update.

     

    I don't know the update frequency about AS OLEDB provider, maybe IlanH can help on this?

     

    Best Regards,
    Qiuyun Yu