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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
mikecox99
New Member

"end of input data reached" on concatenate

Trying to Combine 3 columns from 2 tables. into one field.  

so example: 

Branch: 456

Date:      23

ID:      000378

output contract number: 45623000378 

mikecox99_0-1692119796534.png

I've tried multiple combinations, with brackets, without etc... based on reading.  am consistently getting 

"End of the input was reached".

Any thoughts?   My goal is simply to display those fields as one number.  If i try to merge in power query, once the master branch field is selected, it tells me that it creates a query that won't work within direct query.  this seems like it should be simple.  uhg...

1 REPLY 1
Alef_Ricardo_
Resolver II
Resolver II

Hi mikecox99, it seems like you’re trying to concatenate three columns from two tables into one field in Power Query. You mentioned that you’re getting an error message that says “End of the input was reached” when you try to do this.

 

One possible solution to your problem could be to use the & operator to concatenate the columns. For example, you could create a custom column in Power Query with the formula =[Branch]&[Date]&[ID] to concatenate the three columns into one. This should give you the desired output of 45623000378 for the example you provided.

As for the error message you’re getting when trying to merge in Power Query, it’s possible that the issue is related to using DirectQuery mode. According to a post on the Microsoft Fabric Community, there are some limitations when using DirectQuery mode, and it’s suggested to use a SQL statement to join the queries instead.

 

I hope this helps! Let me know if you have any further questions. 😊

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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