Powerpivot for Excel unable to import Excel files

Anything related to PowerPivot and DAX Formuale
danielco
Posts: 3
Joined: Mon Feb 18, 2019 7:53 pm

Powerpivot for Excel unable to import Excel files

Postby danielco » Mon Feb 18, 2019 8:14 pm

Hello,

Windows 10 fr, Excel 2016.

Powerpivot tab, Manage, Home, Get external data, From other sources doesn't display any dialog box. Other options (From database, From Data Service, Existing connextion) are working fine.

Any idea ?

Thanks in advance.

Daniel

PhilC
Posts: 274
Joined: Tue Sep 09, 2014 8:13 am

Re: Powerpivot for Excel unable to import Excel files

Postby PhilC » Tue Feb 19, 2019 7:11 am

Hi, see attached. Keep scrolling down the list to the bottom to see the option to import an Excel file into PowerPivot.

You might want to do some reading around PowerPivot vs Power Query to import data and load into the data model (which is what PowerPivot is). Using Power Query gives you a lot more flexibility to apply changes to the data prior to loading to the data model.

Historically, loading directly into PowerPivot and then changing the data structure or source caused some issues. I have not used PowerPivot for a couple of years so not sure if those issues persist.

With Power Query (called Get & transform in Excel 2016) embedded in Excel now, ie no longer an AddIn, it is a far superior option for bringing in data to the Excel to use the data model / PowerPivot and DAX measures.



Cheers
Phil
Attachments
PowerPivot Excel import.JPG
PowerPivot Excel import.JPG (51.8 KiB) Viewed 733 times

danielco
Posts: 3
Joined: Mon Feb 18, 2019 7:53 pm

Re: Powerpivot for Excel unable to import Excel files

Postby danielco » Wed Feb 20, 2019 3:28 am

Thanks for the reply. Power Query works fine. I was just wandering why Power Pivot is apparently buggy.

Daniel


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 4 guests