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 to update within the query experience without any issue.
The error occurs as soon as i save the query. Then a "AutoPremiumInvalidIndex" error is shown.
Note the user have a Power BI premium per user license and the workspace have a Fabric F4 license.
Best regards John Mark
2 Comments
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 According to the error message it seems that cross region migration is causing the error, are your two tables from the same data source?
Best Regards,
Community Support Team _ Ailsa Tao
