Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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. I have a measure calculating sum from direct query as well as import mode but the date filter is not filtering the sum correctly , Or if i am filtering for any column from the import mode that is also not giving me the correct value. Is there any work around?
The calendar table is a static measure.
Any suggestions are welcome
regrads
anonymus
Solved! Go to Solution.
Do not join fact tables directly. Let your common dimension tables control the fact tables.
Please, could you explain the magic you did to connect sharepoint with direct query?
Do not join fact tables directly. Let your common dimension tables control the fact tables.
Thank you it worked smoothly
User | Count |
---|---|
85 | |
84 | |
67 | |
61 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |