Forum Discussion

vladislavegorov's avatar
vladislavegorov
New Member
1 year ago
Solved

Excel to PowerPoint connection: Enter password each time you open a file

Hello every one!

 

Given:
1. Corporate PowerBI, corporate Excel.
2. From Excel we connect to the PowerBI dataset, everything works.

 

Problem:
Every time the user opens such a file, he must enter his credentials, although he has already entered Windows under these credentials, he is in Excel under these credentials. How to save the user from having to enter a password every time?

Need Help

2 Replies

  • nilendraFabric's avatar
    nilendraFabric
    Icon for Super User rankSuper User
    1 year ago

    Hello vladislavegorov 

     

    Did you tried this 

     

    • Go to Data > Properties > Definition > Connection String.
    • Change "Provider=MSOLAP.8" to "Provider=MSOLAP.7".
    • Remove "Catalog Rebound=True;" from the connection string.
      Note: It will ask for credentials only once again. Then save, close the workbook, open it back up, press refresh all

    https://community.fabric.microsoft.com/t5/Service/Prompting-for-account-when-trying-to-open-Excel-with-Power-BI/m-p/3638567

     

    if this works please accept the solution 

    Thanks

     

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi vladislavegorov ,

     

    Thank you for reaching out to the Microsoft Fabric community.  Besides the solution from nilendraFabric , here are a few more points that might help.

     

    • Configure Single Sign-On (SSO) for Power BI and Excel.
    • Update both Excel and Power BI to the latest version.
    • Clear all cache data.

    If my answer addressed your query, please mark it as the Accepted Solution so that others can easily find the solution. I would also appreciate a 'Kudos' if you found my response helpful.