+ Reply to Thread
Results 1 to 2 of 2

Power Query - number not loading

  1. 01-13-2019, 09:57 AM #1
    Travman1986
    Travman1986 is offline
    Registered User
    Join Date
    09-14-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    82

    Cool Power Query - number not loading

    Hi,
    I have a power query file with c. 7,000 rows. I noticed that one of the number is showing up as blank when I load the file to Excel. When I investigated in the Power Query editor, however, I am able to see the number.

    Bizarre!

    Any suggestions on how to fix this would be greatly appreciated.
    Reply With QuoteRegister To Reply
  2. 01-13-2019, 04:35 PM #2
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Power Query - number not loading

    Hello,

    can you post a (small!) sample file that shows the issue? Please, not all 7000 rows, just a couple dozen with the "problem" row.

    What is the data type of the column in the PQ editor? Is the value still visible in PQ editor in the last step of the query?
    Microsoft MVP
    http://www.teylyn.com
    Twitter: http://twitter.com/IngeborgNZ
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  2. [SOLVED] Power Query Custom Column: If number in columns a or b are less than 1 then 0 else 1
    By jekeith in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-15-2018, 10:31 AM
  3. [SOLVED] Power Query loading sheets inconsistently
    By armlegx in forum Excel General
    Replies: 9
    Last Post: 05-08-2018, 01:24 PM
  4. Modifications in Power Query not updating in Power BI Service linked via Local Drive Excel
    By ibuhary in forum Excel General
    Replies: 0
    Last Post: 04-05-2018, 01:16 AM
  5. [SOLVED] Power Query Not loading all Rows from Source File
    By jdriscol in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-21-2017, 04:03 PM
  6. Excel 2016 - Power Query - Data Model Loading issues/explanation
    By Ohhaa in forum Excel General
    Replies: 7
    Last Post: 07-25-2017, 08:38 AM
  7. Return closest value less than given number matching another column - Power Query ?
    By ChipsSlave in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-29-2017, 03:16 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1