How to use a Power BI data model across different folders of similar data
I have a system that produces CSV data on a regular event-driven basis (say, daily). Each event triggers the creation of a new folder and a fixed set of CSV files, each representing different types of data. For instance:
- PlansDB.csv - data for plans of action
- StepsDB.csv - descriptions of steps used by different plans
- GroupsDB.csv - data on groups that can handle plans
- RoomsDB.csv - data on places where a group can work on a plan
- ResultsDB.csv - the records of results from steps of a plan
These have fields that identify the relationships between the different files, and I have no problems creating a data model for the CSVs in any given folder.
But how do I switch between folders? Once I have a working data model and some reports built off it, I'd like to view those reports on specific folders of data. How does that work? Can I switch easily to yesterday's folder, or last weeks, etc. with minimal effort (preferably just pointing to the folder).
The CSV files maintain the same names across folders which represent the types of the data they store. Can Power BI use that?
And can I run reports over multiple folders maintaining this data model? I know of the Folder merge capability, but my attempts at using it just merges all files as if they were the same type, whereas I would need each type merged separately.
csv powerbi data-modeling
add a comment |
I have a system that produces CSV data on a regular event-driven basis (say, daily). Each event triggers the creation of a new folder and a fixed set of CSV files, each representing different types of data. For instance:
- PlansDB.csv - data for plans of action
- StepsDB.csv - descriptions of steps used by different plans
- GroupsDB.csv - data on groups that can handle plans
- RoomsDB.csv - data on places where a group can work on a plan
- ResultsDB.csv - the records of results from steps of a plan
These have fields that identify the relationships between the different files, and I have no problems creating a data model for the CSVs in any given folder.
But how do I switch between folders? Once I have a working data model and some reports built off it, I'd like to view those reports on specific folders of data. How does that work? Can I switch easily to yesterday's folder, or last weeks, etc. with minimal effort (preferably just pointing to the folder).
The CSV files maintain the same names across folders which represent the types of the data they store. Can Power BI use that?
And can I run reports over multiple folders maintaining this data model? I know of the Folder merge capability, but my attempts at using it just merges all files as if they were the same type, whereas I would need each type merged separately.
csv powerbi data-modeling
add a comment |
I have a system that produces CSV data on a regular event-driven basis (say, daily). Each event triggers the creation of a new folder and a fixed set of CSV files, each representing different types of data. For instance:
- PlansDB.csv - data for plans of action
- StepsDB.csv - descriptions of steps used by different plans
- GroupsDB.csv - data on groups that can handle plans
- RoomsDB.csv - data on places where a group can work on a plan
- ResultsDB.csv - the records of results from steps of a plan
These have fields that identify the relationships between the different files, and I have no problems creating a data model for the CSVs in any given folder.
But how do I switch between folders? Once I have a working data model and some reports built off it, I'd like to view those reports on specific folders of data. How does that work? Can I switch easily to yesterday's folder, or last weeks, etc. with minimal effort (preferably just pointing to the folder).
The CSV files maintain the same names across folders which represent the types of the data they store. Can Power BI use that?
And can I run reports over multiple folders maintaining this data model? I know of the Folder merge capability, but my attempts at using it just merges all files as if they were the same type, whereas I would need each type merged separately.
csv powerbi data-modeling
I have a system that produces CSV data on a regular event-driven basis (say, daily). Each event triggers the creation of a new folder and a fixed set of CSV files, each representing different types of data. For instance:
- PlansDB.csv - data for plans of action
- StepsDB.csv - descriptions of steps used by different plans
- GroupsDB.csv - data on groups that can handle plans
- RoomsDB.csv - data on places where a group can work on a plan
- ResultsDB.csv - the records of results from steps of a plan
These have fields that identify the relationships between the different files, and I have no problems creating a data model for the CSVs in any given folder.
But how do I switch between folders? Once I have a working data model and some reports built off it, I'd like to view those reports on specific folders of data. How does that work? Can I switch easily to yesterday's folder, or last weeks, etc. with minimal effort (preferably just pointing to the folder).
The CSV files maintain the same names across folders which represent the types of the data they store. Can Power BI use that?
And can I run reports over multiple folders maintaining this data model? I know of the Folder merge capability, but my attempts at using it just merges all files as if they were the same type, whereas I would need each type merged separately.
csv powerbi data-modeling
csv powerbi data-modeling
asked Nov 21 '18 at 18:43
ex0du5ex0du5
2,278913
2,278913
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You need to change the data source. To do this, from "Edit Queries" select "Data source settings":
Then click "Change Source..." button and select the new folder. After that Power BI Desktop will tell you to apply the changes and will reload the data from the new folder:
Thank you for response. This appears to require me to change the source settings for every CSV individually. I was really hoping to just point my report to a new folder in one step as my data model is more complex than the example in my question and there are many different CSVs with elaborate relationships. It will be error prone to have to change all types one by one. I've done some searching but can't seem to figure out how to change the folder all at once.
– ex0du5
Nov 21 '18 at 21:35
add a comment |
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',
autoActivateHeartbeat: false,
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53418661%2fhow-to-use-a-power-bi-data-model-across-different-folders-of-similar-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You need to change the data source. To do this, from "Edit Queries" select "Data source settings":
Then click "Change Source..." button and select the new folder. After that Power BI Desktop will tell you to apply the changes and will reload the data from the new folder:
Thank you for response. This appears to require me to change the source settings for every CSV individually. I was really hoping to just point my report to a new folder in one step as my data model is more complex than the example in my question and there are many different CSVs with elaborate relationships. It will be error prone to have to change all types one by one. I've done some searching but can't seem to figure out how to change the folder all at once.
– ex0du5
Nov 21 '18 at 21:35
add a comment |
You need to change the data source. To do this, from "Edit Queries" select "Data source settings":
Then click "Change Source..." button and select the new folder. After that Power BI Desktop will tell you to apply the changes and will reload the data from the new folder:
Thank you for response. This appears to require me to change the source settings for every CSV individually. I was really hoping to just point my report to a new folder in one step as my data model is more complex than the example in my question and there are many different CSVs with elaborate relationships. It will be error prone to have to change all types one by one. I've done some searching but can't seem to figure out how to change the folder all at once.
– ex0du5
Nov 21 '18 at 21:35
add a comment |
You need to change the data source. To do this, from "Edit Queries" select "Data source settings":
Then click "Change Source..." button and select the new folder. After that Power BI Desktop will tell you to apply the changes and will reload the data from the new folder:
You need to change the data source. To do this, from "Edit Queries" select "Data source settings":
Then click "Change Source..." button and select the new folder. After that Power BI Desktop will tell you to apply the changes and will reload the data from the new folder:
answered Nov 21 '18 at 20:34
Andrey NikolovAndrey Nikolov
4,2633822
4,2633822
Thank you for response. This appears to require me to change the source settings for every CSV individually. I was really hoping to just point my report to a new folder in one step as my data model is more complex than the example in my question and there are many different CSVs with elaborate relationships. It will be error prone to have to change all types one by one. I've done some searching but can't seem to figure out how to change the folder all at once.
– ex0du5
Nov 21 '18 at 21:35
add a comment |
Thank you for response. This appears to require me to change the source settings for every CSV individually. I was really hoping to just point my report to a new folder in one step as my data model is more complex than the example in my question and there are many different CSVs with elaborate relationships. It will be error prone to have to change all types one by one. I've done some searching but can't seem to figure out how to change the folder all at once.
– ex0du5
Nov 21 '18 at 21:35
Thank you for response. This appears to require me to change the source settings for every CSV individually. I was really hoping to just point my report to a new folder in one step as my data model is more complex than the example in my question and there are many different CSVs with elaborate relationships. It will be error prone to have to change all types one by one. I've done some searching but can't seem to figure out how to change the folder all at once.
– ex0du5
Nov 21 '18 at 21:35
Thank you for response. This appears to require me to change the source settings for every CSV individually. I was really hoping to just point my report to a new folder in one step as my data model is more complex than the example in my question and there are many different CSVs with elaborate relationships. It will be error prone to have to change all types one by one. I've done some searching but can't seem to figure out how to change the folder all at once.
– ex0du5
Nov 21 '18 at 21:35
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53418661%2fhow-to-use-a-power-bi-data-model-across-different-folders-of-similar-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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