How to use a Power BI data model across different folders of similar data
up vote
0
down vote
favorite
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
asked Nov 21 at 18:43
ex0du5
2,278913
add a comment |
up vote
0
down vote
favorite
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
asked Nov 21 at 18:43
ex0du5
2,278913
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
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
asked Nov 21 at 18:43
ex0du5
2,278913
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 at 18:43
ex0du5
2,278913
asked Nov 21 at 18:43
ex0du5
2,278913
asked Nov 21 at 18:43
ex0du5
2,278913
asked Nov 21 at 18:43
ex0du5
2,278913
asked Nov 21 at 18:43
ex0du5
2,278913
2,278913
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
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 at 20:34
Andrey Nikolov
2,4081317
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 at 21:35
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
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 at 20:34
Andrey Nikolov
2,4081317
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 at 21:35
add a comment |
up vote
1
down vote
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 at 20:34
Andrey Nikolov
2,4081317
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 at 21:35
add a comment |
up vote
1
down vote
up vote
1
down vote
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 at 20:34
Andrey Nikolov
2,4081317
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 at 20:34
Andrey Nikolov
2,4081317
answered Nov 21 at 20:34
Andrey Nikolov
2,4081317
answered Nov 21 at 20:34
Andrey Nikolov
2,4081317
answered Nov 21 at 20:34
Andrey Nikolov
2,4081317
2,4081317
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 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 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 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 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.
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.
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
