Powerbi modelling for multiple dataset
Budget: $30 – $250 CAD
Need a powerbi data model that combine
1. Excel file
2. Excel file matching similar header as excel1 but different data
3. Excel file different dataset and column header information
4. Ms project file
I need to combine all these data sets together into one dataset. It’s mainly union all data not really a true 1-1 relationship. They may have or not have that kind of relationship.
Then out of this report I need a report on a site name (one column in each dataset but having different data and different column header)
Report should be able to show me all the site names combined from different datasets and then once I click a site name I get more information from each report about that site name. There might be same sitename in different datasets. So the report will combine these datasets for that site name.
I need step by step guide and also a demo model.
1. Excel file
2. Excel file matching similar header as excel1 but different data
3. Excel file different dataset and column header information
4. Ms project file
I need to combine all these data sets together into one dataset. It’s mainly union all data not really a true 1-1 relationship. They may have or not have that kind of relationship.
Then out of this report I need a report on a site name (one column in each dataset but having different data and different column header)
Report should be able to show me all the site names combined from different datasets and then once I click a site name I get more information from each report about that site name. There might be same sitename in different datasets. So the report will combine these datasets for that site name.
I need step by step guide and also a demo model.