Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
i have 1 date table and two fact tables. I want to concatenate load both fact tables into one fact table.
Thing is that both tables contain the same date field name (which is fine) and the idea is to link that field to the date table.
PowerBI comes with this message : Item 'field name' already exists in the collection.
Thanks in advanced
Solved! Go to Solution.
I'm not sure what you mean exactly by "drop the appended table". I dont think you should delete any objects.
Perhaps what you are after is to go to the Query Settings / Properties / All Properties, then uncheck Enable load to report.
This will keep the Query definition, but not show it as a table in the various downstream views of the data model.
I would start with 2 Queries - one for each Fact table. Then I would open 1 and add an Append step to add the data from the other Fact table as extra rows.
That step will automatically load each columns from both Fact tables into a single column, where the column names match exactly. Unmatched columns will still be added, but values will be null for rows from the other Fact table.
Then you can define the relationship to the Date table, based on the result.
This works thanks!
is it now also possible to drop the appended table? cause it's not needed anymore
Or is it not possible to load and concatenate it at the same time? Cause now the same table is loaded twice right?
I'm not sure what you mean exactly by "drop the appended table". I dont think you should delete any objects.
Perhaps what you are after is to go to the Query Settings / Properties / All Properties, then uncheck Enable load to report.
This will keep the Query definition, but not show it as a table in the various downstream views of the data model.
Thanks... that did the job
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |