Combining data sets to one source

[espinozan]

Hello All,

I have a dilemma and I'm not sure about the best way to get around it. I'm trying to achieve and create what I call a Power BI data template. 

So far, I have one excel spreadsheet that feeds Power BI for all of my visualizations. I'm trying to keep it that way to make it easier to load data in the future once the report is complete. This spreadsheet will hold sales, cost and margin data from 3 different ERP sysytems. The reports being pulled from these sources are currently in three different formats . 

My question is, how can I combine these three reports in one spreadsheet to make it easier to load the new data into Power BI? Please advise.

[v-yuezhe-msft]

@espinozan,

If you want to combine datasets to one source in Excel, please post the question in the Excel forum to get dedicated support.

In Power BI Desktop, you are able to connect to different data sources or different sheets of Excel to get data. After importing data from different sources, you can create a new table to hold the information you want.

Regard,
Lydia