Forum Discussion

AmateurBI's avatar
AmateurBI
Regular Visitor
9 years ago

Import multiple MS Office Data Connection files from PowerPivot to ONE PowerBI Model

Hey guys,   i have the following situation that I'm trying to deal with:   Each month I get around 1.3 million rows of data. I'm splitting it into two MS Excel tabs in one worksheet (so e.g. July...
Need Help
Show and Tell
AmateurBI's avatar
AmateurBI
Regular Visitor
9 years ago

Hi v-qiuyu-msft,

 

yes, that's correct. I have two different sheets July1 and July2 within the same workbook.

 

So, basically if I wanto to import more months, than I would have to add them to the datamodel of the PowerPivot file?

 

I mean, if that is not reallly working out, I could still import the sheets one by one and combine them within PowerBI, right?

 

Thanks for your help! I will check out your links and see if there's anything useful for my case :)

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi AmateurBI,

 

1. So, basically if I wanto to import more months, than I would have to add them to the datamodel of the PowerPivot file?

 

Yes, you need to add new sheet table into model via Add to Data model option.

 

2. I mean, if that is not reallly working out, I could still import the sheets one by one and combine them within PowerBI, right?

 

Without create PowerPivot model in Excel, you can get data from multiple sheets within one workbook in Power BI desktop directly. You can go through articles listed under Transform and shape data here.

 

Best Regards,

Qiuyun Yu