Status:
Needs Info
Calculated Query in Fabric Datamart - Result in "AutoPremiumInvalidIndex" Error
Hello Whenever using a calculated query in a fabric datamart it result in an error. Note: The query is set up properly, by it showing the right value in the preview pane - also the query is able ...
You can simulate this error by create a Datamart with 2 query
Query 1:
| Column 1 (Id) | Column 2 (name) |
| A | Alpha |
| B | Bravo |
| C | Charlie |
Query 2:
| Column 1 (Id) | Column 2 (id) |
| 1 | A |
| 2 | B |
| 3 | C |
Then create a merge query for query 2 to get the names in query 1. (Query 2 should look like this):
| Column 1 (Id) | Column 2 (id) | Merge Coloum (from query 1 - name) |
| 1 | A | Aplha |
| 2 | B | Bravo |
| 3 | C | Charlie |