Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous11847
New Member

Power query using another workbook as source truncates text fields

I was referred here from the answers.microsoft.com community (Microsoft 365 and Office /  Excel / For home / Windows)  because Power Query questions are "beyond the scope" of that group, apparently...  I am NOT using Power BI, however, I'm using Excel.

 

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?

 

3 REPLIES 3
KT_Bsmart2gethe
Impactful Individual
Impactful Individual

Hi @Anonymous11847 ,

 

 

Would you be able to provide some sample data with sensitive information removed as well as your desired outcome?

 

 

Regards

KT

Well, that's interesting.

 

I was going through, step by step, to see exactly where in the process the field was being truncated.  I had inserted a filter step to find a particular task I could post, as an example.  I don't think that I changed any of my original steps but, through this process -- it now looks like is no longer truncating that field.

 

Very weird.

 

This is a weekly process that I run.  I'm going to see if it works again next week, and will update this post then, if that's okay.

I'm curious if the original file you were importing was actually exported from another system.  I ran into the same issue.  My solution was to open the data file and re-save it.  Then the fields that were getting truncated to 255 characters imported fully.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.