Import & DirectQuery mode issue on SSAS cubes

Question

Dears,

I'm facing this error when i need to convert default mode from import to direct query , anyone can help me , i can't reach to tmitransaction.inl file!

Failed to save modifications to the server. Error returned: 'An unexpected error occurred (file 'tmitransaction.inl', line 102, function 'IslandFromPartition').
'. (Microsoft.AnalysisServices.Tabular)

Answer 1

Hi,
This error description is too ambiguous to find out what exactly the issue is .
But you could try first to change the mode in Visual Studio , which might be less troublesome.
You could follow the steps in Enable DirectQuery mode in Visual Studio

Regards,
Lukas

Answer 2

@Lukas Yu -MSFT

I can reproduce the same exact issue:

I have an SSAS Tabular model that was created in Visual Studio and deployed. If I go to the SSAS Tabular database in SSMS > Options > Model I can see that it is in Import mode. Now in Visual Studio when I open the project for this deployed Tabular Model I can see the Direct Query option but it is greyed/disabled out and I cannot change the value. As shown below:

I looked at the documentation for DirectQuery mode in tabular models here https://learn.microsoft.com/en-us/analysis-services/tabular-models/directquery-mode-ssas-tabular?view=asallproducts-allversions and it says "DirectQuery mode can be turned on for models you're designing in Visual Studio, or for tabular models that have already been deployed, you can change to DirectQuery mode in SSMS." I am assuming DirectQuery is disabled in Visual Studio because the model is already deployed so I need to change it in SSMS, like this documentation says.

If I try to change the DefaultMode from Import to Direct Query I can reproduce the same exact issue as @Osama Abu Asal has reported:

I think this is a bug we need to report.

Answer 3

The problem has to do with bug, MSFT fixed in a cumulative update - https://developercommunity.visualstudio.com/content/problem/856964/unexpected-error-related-to-relationships.html?inRegister=true

Never thing to install the latest update sometimes and that does the trick

Thanks,
Thomas

Answer 4

Is someone still experiencing this problem?
I am having problem creating even the simplest relationships between tables when in direct query mode.
Here is something I tried so far but it always led me to this error message:

1. Creating relationship between tables in import mode and try to convert it afterwards to direct query mode.
2. Start direct query project from the scratch and try to build relationship between 2 tables

I am using VS Community edition v 16.11.17 and Microsoft analysis services project v 2.9.18

Answer 5

Hi all,
I managed to solve this particular problem after changing to integrated workspace mode.
However now i have another problem "An error occurred while parallel saving VertiPaq data objects for Schema 'db'.'" and i created new post on that subject

https://learn.microsoft.com/en-us/answers/questions/967414/an-error-occurred-while-parallel-saving-vertipaq-d.html