Data Source Credentials issue with Excel PowerPivot
2014-04
user359650
I am using Excel 2010 with PowerPivot. I am trying to go to the Query Editor. When I click on Table Properties, I get a password prompt:
The problem is that I don't know the password and when I press OK, I get a User name or password is invalid error:
I've never had this issue before. The problem started to occur when performing those steps via different computers than the one the spreadsheet was initially created with. Unfortunately I can't open the spreadsheet with the original computer as it went missing.
Is there a way to bypass the Data Source Credentials (I've never had to enter any before)?
user359650
OK, problem wasn't related to credentials but to data path. After acknowledging the error message, you get another error at the bottom of the table properties window:
That's what made me realize it could be related to data paths. When clicking on Existing Connections I realized files were mapped under a different drive. Creating that drive on the new computer fixed the issue.
Chris
I have an Excel workbook that has 30 plus pivot tables and 10 plus slicers connected to PowerPivot. When we filter data based on these slicers the performance is sub par, 30 sec to 2 minutes. Is there a strategy for improving this performance?
masterjo
Things I did to improve the performance of my PowerPivot files:
- check for unecessary calculated columns on table-level
- check and re-check measures (is every measure necessary? are they calculated in an efficient way?)
- are the slices only connected to the relevant tables and don't interfere with each other?
Another strategy could be to save a backup of the original file and delete some of those tables or slices step-by-step to narrow down if there is a specific set of slicers which are especially time-consuming and focuse on those first.
For more general statements than that it would be helpful to see some examples.