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
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
