Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have 4 facts table and have this model as follows:
Table 1
Key Index
- Emp No
- Hire Date
- Termination Date
Table 2
Key Index
- Emp No
- Date
Table 3
Key Index
- Emp No
- Date
Table 3
Key Index
- Emp No
- Date
Calendar
- Date
below is the diagram for easy understanding.
My question is how can i link table 2 [date] , table 3 [date] and table 4 [date] to calendar[date] keeping star schema model.
Or is there a way to do measure keeping table 1 related to calendar and not table 2,3 and 4?
Thanks for your help.
Regards,
Post a screenshot of your 'Model' tab in Power BI.
Hi @CJ_96601 ,
Can't you just use 1 Emp table (append them)...
Also, why do you need those 3 tables, once you have the data on table 1 ?
Ricardo
Hello @camargos88
Thank you for your response.
Tables are from our ERP via ODBC. I tried append but refresh takes forever.
Is there any other solution, until append is fix.
Regards,
Are you using import or direct query ?
Why don't you submit a query to your source like:
TABLE 1 UNION ALL TABLE 2 UNION ALL TABLE 3....
Also, check this link, maybe it's gonna help with your model:
https://radacad.com/directquery-live-connection-or-import-data-tough-decision
Ricardo
On another note, i know this is not related to my previous question, please refer to the screen shot below:
Why bar graph ended up that way , when using below measure?
It looks like a problem with your model design, check the table connections.
Would help if you post how you are connections those tables. But try to be simple with the model, redesign it with the append ou union.
Ricardo
Once you have the queries, you can go to Advanced Mode e write your custom query:
I will try this once things get back to normal and revert.
I have no VPN at the moment and lockdown is in place...
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |