Forum Discussion

JoachimSA's avatar
JoachimSA
Helper II
4 years ago
Solved

Calculated Table based on DQ into PBI Dataset

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 !?


  • 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.

1 Reply

  • 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.