Calculated Query in Fabric Datamart - Result in "AutoPremiumInvalidIndex" Error

[JohnMarkPerez]

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

[JohnMarkPerez]

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

[Anonymous]

Hi @JohnMarkPerez 

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