Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

JohnMarkPerez_0-1719222404491.png

Best regards John Mark

Status: Needs Info

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

Comments
JohnMarkPerez
Frequent Visitor

You can simulate this error by create a Datamart with 2 query
Query 1:

Column 1 (Id)Column 2 (name)
AAlpha
BBravo
CCharlie

Query 2:

Column 1 (Id)Column 2 (id)
1A
2B
3C

 

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)
1AAplha
2BBravo
3CCharlie
v-yetao1-msft
Community Support
Status changed to: Needs Info

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