cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bgumma
New Member

How to Migrate 100's of Power Pivot Excel workbooks from SharePoint 2013 On-Premesis to SPO

Hi Team ,

would like to get some help to know the best way to migrate large number of [I.e. More than 1500 ] Power Pivot Excel workbooks from SharePoint 2013 On-Premesis to SharePoint Online.

As per my research we do have only one method suggested by Microsoft i.e. Import Pivot Excel workbook into Power BI Manually.

Right now , in my current assignment I've a scenario like we do have 100's of Power Pivot excel workbooks are there in SharePoint 2013 and we've to migrate it to SharePoint Online

as part of migration.

Could you please share your thought's (or) suggestions on this .

Thanks,
Babu.

4 REPLIES 4
Prateeek
Microsoft
Microsoft

test


@bgumma wrote:

Hi Team ,

would like to get some help to know the best way to migrate large number of [I.e. More than 1500 ] Power Pivot Excel workbooks from SharePoint 2013 On-Premesis to SharePoint Online.

As per my research we do have only one method suggested by Microsoft i.e. Import Pivot Excel workbook into Power BI Manually.

Right now , in my current assignment I've a scenario like we do have 100's of Power Pivot excel workbooks are there in SharePoint 2013 and we've to migrate it to SharePoint Online

as part of migration.

Could you please share your thought's (or) suggestions on this .

Thanks,
Babu.


test

v-shex-msft
Community Support
Community Support

Hi @bgumma ,

Maybe you can try to use sharepoint folder to get data and combine same structure work sheets.

Combining Excel Files hosted on a SharePoint folder with Power BI

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi @Xiaoxin Sheng,

 

Thanks for your suggestion , I've followed the same with Plain Excel Workbooks and works well . Even I'm able to do the data refresh and scheduling also for those files in Power BI.

 

But the problem is with the Power Pivot Report Excel Workbooks , whenever I have followed the same process as above with the Power Pivot Excel Workbooks Data Refresh / Scheduling is not supporting by Power BI.

 

And the data in the excel file is pulling from SharePoint Lists . Please let me know if you've any Idea how to manage data refresh for Power Pivot (or) is there any restriction form Power BI for Power Pivot.

 

Thanks , 

Babu.

Hi @bgumma ,

Did you apply any advanced operations to merge online and on premises data source? AFAIK, scheduled refresh not suitable with mixed datasource tables.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!