Power Pivot Table - How can I determine where the data for a table came from?











up vote
0
down vote

favorite












I have an Excel workbook with a Power Pivot model. When I open the workbook and select Manage Data Model, I'm taken to the Power Pivot screen. There are seven tables compromising the model. I'm trying to determine where data is coming from for one of the tables. When I click on the tab associated with the table, and select the Design menu option, the Table Properties button is disabled. However, there is no link icon in the tab name indicating a link to another table in the model. So, my question is, in this case, how do I determine where this data came from?



The original designer of this model isn't readily available at the moment.






excel powerpivot







share|improve this question






















  • Have you checked the Connections in Data card as the data may be coming from external sources and loaded into Data Model.
    – zipa
    Nov 22 at 14:50










  • Try checking the query editor too.
    – Alexis Olson
    Nov 23 at 1:52















up vote
0
down vote

favorite












I have an Excel workbook with a Power Pivot model. When I open the workbook and select Manage Data Model, I'm taken to the Power Pivot screen. There are seven tables compromising the model. I'm trying to determine where data is coming from for one of the tables. When I click on the tab associated with the table, and select the Design menu option, the Table Properties button is disabled. However, there is no link icon in the tab name indicating a link to another table in the model. So, my question is, in this case, how do I determine where this data came from?



The original designer of this model isn't readily available at the moment.






excel powerpivot







share|improve this question






















  • Have you checked the Connections in Data card as the data may be coming from external sources and loaded into Data Model.
    – zipa
    Nov 22 at 14:50










  • Try checking the query editor too.
    – Alexis Olson
    Nov 23 at 1:52













up vote
0
down vote

favorite









up vote
0
down vote

favorite











I have an Excel workbook with a Power Pivot model. When I open the workbook and select Manage Data Model, I'm taken to the Power Pivot screen. There are seven tables compromising the model. I'm trying to determine where data is coming from for one of the tables. When I click on the tab associated with the table, and select the Design menu option, the Table Properties button is disabled. However, there is no link icon in the tab name indicating a link to another table in the model. So, my question is, in this case, how do I determine where this data came from?



The original designer of this model isn't readily available at the moment.






excel powerpivot







share|improve this question













I have an Excel workbook with a Power Pivot model. When I open the workbook and select Manage Data Model, I'm taken to the Power Pivot screen. There are seven tables compromising the model. I'm trying to determine where data is coming from for one of the tables. When I click on the tab associated with the table, and select the Design menu option, the Table Properties button is disabled. However, there is no link icon in the tab name indicating a link to another table in the model. So, my question is, in this case, how do I determine where this data came from?



The original designer of this model isn't readily available at the moment.






excel powerpivot




excel powerpivot






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 22 at 14:31









Randy Minder

29.7k37143254




29.7k37143254












  • Have you checked the Connections in Data card as the data may be coming from external sources and loaded into Data Model.
    – zipa
    Nov 22 at 14:50










  • Try checking the query editor too.
    – Alexis Olson
    Nov 23 at 1:52


















  • Have you checked the Connections in Data card as the data may be coming from external sources and loaded into Data Model.
    – zipa
    Nov 22 at 14:50










  • Try checking the query editor too.
    – Alexis Olson
    Nov 23 at 1:52
















Have you checked the Connections in Data card as the data may be coming from external sources and loaded into Data Model.
– zipa
Nov 22 at 14:50




Have you checked the Connections in Data card as the data may be coming from external sources and loaded into Data Model.
– zipa
Nov 22 at 14:50












Try checking the query editor too.
– Alexis Olson
Nov 23 at 1:52




Try checking the query editor too.
– Alexis Olson
Nov 23 at 1:52

















active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53433160%2fpower-pivot-table-how-can-i-determine-where-the-data-for-a-table-came-from%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown






























active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes
















draft saved

draft discarded




















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid …



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.





Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


Please pay close attention to the following guidance:


  • Please be sure to answer the question. Provide details and share your research!

But avoid …



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53433160%2fpower-pivot-table-how-can-i-determine-where-the-data-for-a-table-came-from%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







-