cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
BigByteBooks Frequent Visitor
Frequent Visitor

Multiple Excel sources and many products

Hi experts,

 

I have four years of sales data on over 600 products. All of that data is in 45 Excel spreadsheets by month. There are all kinds of things I'd like to do with this but the most important right now is to graph the effect of price point against royalty.

 

In other words, for any single product ID, I want to be able to see IF there is an effect of price point on royalty and hopefully find the sweet spot. So I need to see across time the changes in price point and the effect, if any, on royalty totals.

 

Because this data is spread among so many sources, should I first combine the spreadsheets rather than importing each one and then creating a dashboard report that I can filter on various fields?

 

Thanks in advance for any input.

1 ACCEPTED SOLUTION

Accepted Solutions
CheenuSing Super Contributor
Super Contributor

Re: Multiple Excel sources and many products

@BigByteBooks

 

It is better to combine the 45 excel sheets into a single one and then import into Power BI

Which version of Excel are you using.  Make sure the version you are using is able to accommodate all the data into a single sheet in the combined excel file.  Otherwise you will have formulate you own strategy of combining few excel files into one and hence have a limited number of excel files to be imported. 

If you are loading mutiple excel files of some data structure then you should append the data from each file to the data model and not create as different tables in the model.  Check out on appending data to existing data model.

 

Cheers

 

CheenuSing

 

 

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
2 REPLIES 2
CheenuSing Super Contributor
Super Contributor

Re: Multiple Excel sources and many products

@BigByteBooks

 

It is better to combine the 45 excel sheets into a single one and then import into Power BI

Which version of Excel are you using.  Make sure the version you are using is able to accommodate all the data into a single sheet in the combined excel file.  Otherwise you will have formulate you own strategy of combining few excel files into one and hence have a limited number of excel files to be imported. 

If you are loading mutiple excel files of some data structure then you should append the data from each file to the data model and not create as different tables in the model.  Check out on appending data to existing data model.

 

Cheers

 

CheenuSing

 

 

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
BigByteBooks Frequent Visitor
Frequent Visitor

Re: Multiple Excel sources and many products

 Thanks, CheenuSing.

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 300 members 4,011 guests
Please welcome our newest community members: