The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Trying to Combine 3 columns from 2 tables. into one field.
so example:
Branch: 456
Date: 23
ID: 000378
output contract number: 45623000378
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...
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. 😊