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 en...
Need Help
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