Calculated Table based on DQ into PBI Dataset

[JoachimSA]

Dear all,

I am using the new feature to access a remote PBI Dataset using direct query. I select only the 2 table that I need in my local model and build "codensed" versions of them by using SELECTCOLUMNS.
This works fine until I try to add a new column.

Then I see a black command line window showing for a split second ( titled SQL DUmp or something similar ).
After I am presented with an error:

Unexpected Error (File "tmitransaction.inl", Row 129, Function "TMRelationshipResolver::IslandFromPartition").

What I figured out: I need to delete the Calculated Table and create it new - then it works fine accepting all my additional columns I would like to include for example....very tedious and likely a bug !?

[v-yanjiang-msft · Accepted solution]

Hi @JoachimSA ,

Similar issue had been submitted internal(ICM: 262035755) and got solved, you can try the workaround:

Disable Time intelligence in Options and settings in Power BI Desktop.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.