Forum Discussion

anonymus's avatar
anonymus
Frequent Visitor
3 years ago
Solved

Relationship issue with direct query and import mode table

Hello, I am working on a composite model which has table coming from a direct query and sharepoint to power BI, both table are facts table. I am trying to connect both the table to a calendar table....
  • lbendlin's avatar
    3 years ago

    Do not join fact tables directly.  Let your common dimension tables control the fact tables.

  • anonymus's avatar
    anonymus
    3 years ago

    Thank you it worked smoothly