Preview the data after importing

[Shay A]

Hello,
Does anyone know if this issue has been resolved?

https://answers.microsoft.com/en-us...r/5586d0c2-3d0d-441e-87ab-74c002615b52?auth=1



I couldn't find it anywhere.

Thank you,
Shay

 

[Chihiro]

Not that I'm aware of. Normally, I don't recommend loading data directly from PowerPivot wizard. Always go through PowerQuery/Get & Transform and perform all your data transformation there, and then load to data model.

 

[Shay A]

May I ask why you don't recommend this method?

TY,
Shay

 

[Chihiro]

PowerQuery is the tool for data transformation and clean up. Then PowerPivot is used for modeling and analysis.

It's always best to ensure proper data type and format before data is loaded to model.

 

[GraH - Guido]

Not that I'm aware of. Normally, I don't recommend loading data directly from PowerPivot wizard. Always go through PowerQuery/Get & Transform and perform all your data transformation there, and then load to data model.

Yes, though in version 2010 this is very hard to achieve and officially not supported by MS. But a charm in later versions...