REST API? More like UNREST! Duplicate list names break you!

8 06 2016

Lesson learned! So for the last two days i have been tackling what i thought was a powerpivot issue. But it wasn’t.
Suddenly all powerpivot refreshes broke. Why? Because of a migration. Why? Now that is the million dollar question.
Going through all the troubleshooting steps for powerpivot, I came across this gem of an error:
Error Message: ============================ The remote server returned an error: (500) Internal Server Error. ============================ Call Stack: ============================ at Microsoft.AnalysisServices.Common.DataSourceBasic.UpdateDataFeedParameters(ConnectionStringBuilder connBuilder, IDataSource dataSource, Boolean checkFeedValid) at Microsoft.AnalysisServices.Common.DataSourceBasic.GetCurrentConnectionString(Boolean checkFeedValid) at Microsoft.AnalysisServices.Common.DataSourceBasic.ClickTestConnection(Object progressControl) ============================

So naturally i googled the bejesus out of this and found some reference to illegal characters. But that wasn’t the answer. It was close but not quite.

It turns out that you CANNOT have duplicate List names in the same site. This includes Document libraries and list combinations. During the migration, a list was brought over that had the same name as an existing library.

This was a tough one to diagnose and worthy of a DOJO post.






Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: