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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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