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.