question

JamesWalsh-3977 avatar image
0 Votes"
JamesWalsh-3977 asked VikiJi-MSFT commented

Unable to save ID and password for data feed connection - Excel

I have several users who are unable to to connect or edit a data feed in Excel/PowerPivot

When trying to edit the connection the data feed the user needs to click advanced and enter their User ID and password.
Upon testing the connection they will get a test successful message showing that it's working.
Once they hit okay and get to the page to save the new connection details, this will error out stating they need to enter their User ID and Password, however this was confirmed to work when tested.

If you go back into the advanced these have now been removed.

This is also the same if you run the test, hit okay and go back into the advanced settings before hitting save.

The user stated this was after a recent update which would have been feature update 20h2.

Looking at Event viewer i can see Event ID 25 from source MSOLAP$Local Cube is present.
We've tried moving to 21h1, running sfc scan, removing the add in and adding it back.
This happens across several users and not just one machine.

Similar issue to Similar: https://social.technet.microsoft.com/Forums/lync/en-US/4a66e8ca-078d-40e3-8fec-409996716f41/event-id-25-from-source-msolaplocalcube?forum=powerquery

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

VikiJi-MSFT avatar image
0 Votes"
VikiJi-MSFT answered VikiJi-MSFT commented

Hi @JamesWalsh-3977,
Welcome to Q&A forum!

Which version of Office are you using? Please update it to the latest version first.
To better analyze this issue, could you please provide more screenshots of prompt messages to us? Thanks.

Consideration that this issue occured after updating to 20H2, please check if it occurs after rolling back to 20H1 on a test machine.

Besides, I found the following official KBs, please check if they are helpful to you.
The password you use to connect to the server is not saved when you import data from a server by using ODBC Connection in Excel
Cannot modify the oData connections in an Excel 2013 PowerPivot workbook

Any updates, please let me know.


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JamesWalsh-3977,
Are there any updates or questions? Please feel free to post back.
Thanks.

0 Votes 0 ·