Power BI merge query in SSAS Tabular 1400
Hello guys,
In Power BI, I'm able to merge two tables easily because you can (even with csv files) add new queries and merge them in two clicks.
What I need is to reproduce the same merge in Tabular 1400. The thing is that the source tables are two CSV files located in different folders. I succeed making the merge in M language before the import.
Here are my tables
And here is the merge one
So, as you can see it is working until there. But once I click on import, there is an error message saying that The name 'Table2' wasn't recognized. Make sure it's spelled correctly
So it must be related to the M language behind the merge but for me it is correct. Here is the M language
let
Source = Table.NestedJoin(Table2,{"Name"},Table1,{"Name"},"NewColumn",JoinKind.LeftOuter),
#"Expanded NewColumn" = Table.ExpandTableColumn(Source, "NewColumn", {"Name", "Age", "Country"}, {"NewColumn.Name", "NewColumn.Age", "NewColumn.Country"}),
#"Removed Columns" = Table.RemoveColumns(#"Expanded NewColumn",{"NewColumn.Name"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"NewColumn.Age", "Age"}, {"NewColumn.Country", "Country"}}),
#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Age", Int64.Type}})
in
#"Changed Type"
I'm a bit lost actually because for me the M language is good. Any idea how to figure it out ?
I found the solution. I was using an old version of SSDT. I replace it with the 17.4 version and now I just have to right click on the table while importing and uncheck Create New Table. That way, Only one table will be imported and the other one will be available for a futur merge.
If you need more informations let me know.
- how do i create a merge request from a fork in gitlab
- Merge rows of two 2d arrays based on shared column values
- Left join using data.table
- Merge/flatten an array of arrays
- Use MERGE with CTE
- Debugging algorithm that merges two lists that are already sorted using circular shifts
- Append the keys of an associative array as values of another array
- How to redo a merge conflict resolution (before committing the merge)?
- Merge PHP const arrays to new const array without nesting
- Error "Updates were rejected because the remote contains work that you do not have locally"
- How to untar multiple files with an extension .tar.gz.aa, .tar.gz.ab..... in windows?
- different deleting OUTPUT behaviour based on source table
- Gitlab CI Pipeline that runs after merge is done
- in jq, how to merge an array of object into 1 object with an array of values
- Deep merge dictionaries of dictionaries in Python
- Group and merge rows in a 2d arrays if they have the same column value
- Recursively merge two associative 2d arrays
- Merge two flat associative arrays by intersecting key to form an associative array of indexed arrays
- Merge associative rows of two 2d arrays related by a shared column values
- Merge row data from multiple arrays by first level indexes
- Merge and transpose multiple flat associative arrays into a 2d array with null values where column values are missing
- Merge two CSV files based on a data from the first column
- How to merge json object with same keys?
- Merging dictionaries in C#
- Git - how to merge a branch, but ignore one of the changes
- What is the best way to merge two lists by markers inside them?
- Merge insert with select statement
- What's the difference between 'git merge' and 'git rebase'?
- Create a new variable based on non-existing values on another variable in R dataframe
- Merge two dataframes and keep non-missing entries