Excel Powerquery: values not loading in excel, but visible in powerquery editor

Koen92

New member
Joined
Jan 8, 2019
Messages
2
Reaction score
0
Points
0
Excel Version(s)
Office 365
Hi,

I'm new to this forum - read there are a lot of experts hanging around here :)

Struggling with the following in Excel, using a powerquery:
- Have made my selections/query in powerquery to retreive data from Sharepoint server
- Data in powerquery editor is exactly how I wish to have it in Excel
> text is succesfully loaded in excel, but numbers are not loading. Only see zeros, but in editor i can see the numbers.

Have already tried setting the relevant columns to either text or numbers, but doesn't do the trick.

Someone able to help me on this?
Thanks!
Koen
 
Back
Top