Results 1 to 2 of 2

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

  1. #1
    Neophyte Koen92's Avatar
    Join Date
    Jan 2019
    Posts
    2
    Articles
    0
    Excel Version
    Office 365

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Neophyte Koen92's Avatar
    Join Date
    Jan 2019
    Posts
    2
    Articles
    0
    Excel Version
    Office 365
    Click image for larger version. 

Name:	2.PNG 
Views:	15 
Size:	2.8 KB 
ID:	8769 Click image for larger version. 

Name:	1.PNG 
Views:	13 
Size:	5.1 KB 
ID:	8770

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •