Hi Could you please help me with a PowerPivot question?
The data file in Excel format is of huge size 500M+. It’s the source data and stored on OneDrive.
I want to create a Pivot table based on above source file and save it as a separate file. The final size shall be much smaller.
I tried hours exploring the use of PowerPivot with file stored on OneDrive, also Googled and read through some materials, but still can’t get the right way and even don’t know how to import the data properly.
Where can I find the tutorial and step-by-step guide of it?