Share via

Power query using another workbook as source truncates text fields

Anonymous
2022-09-24T23:49:13+00:00

I have a data source in one workbook ("ThisWeek") that points to a table in another workbook ("Tasks"). I have to have Tasks open for this to work but text fields are getting truncated - at 255 characters.

If I paste the data that I want to query into a test workbook and use the local data as the source of the query - it does not get truncated.

Is there any way to get around this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-09-25T05:35:21+00:00

    Hello Anonymous11847,

    Welcome to the Microsoft community.

    I hate to give you bad news, but the problem with Power Query is beyond the scope of Answers Support Community. The best place to get help with Power Query is Microsoft Power BI Community , which specializes in dealing with Power Query related issues.

    Here **** is a link to the forum where you can raise specific scenarios and share your idea to help solve the problem.

    I won't be able to help you, but I'll leave this question open if one of our amazing volunteers has ideas for you.

    Thank you for your understanding and support.

    Sincerely

    Mavis - | MSFT Microsoft Community Support Specialist

    Was this answer helpful?

    0 comments