Power query not loading numbers

StokesXD 0 Reputation points

Hello Every one,

I use a query made out of excel files stored in a folder.

On a regular basis, I add an excel file in the folder and refresh the query.

Since the update of the 30th of May, when I refresh the query, every columns are loaded and added to the query, but the columns with the numbers aren't. They are left empty.

The format of the excel file added this month is the same than the one already in.

I tried to change the type of the numbers, it doesn't solve the issue.

I don't know why the columns with the numbers aren't loading in the query.

Do you have an idea how to solve this issue?

Kind regards,

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,670 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Jiajing Hua-MFST 7,545 Reputation points Microsoft Vendor

    Hi @StokesXD

    I suggest you post a new thread in this forum: https://community.fabric.microsoft.com/t5/Power-Query/bd-p/power-bi-services

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments