March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
I currently have a table in my dataset from SQL which has a column named 'RegistrationLog_id', which is for when different companies submit registration details, which can be more than once (i.e. multiple rows of the same company_id but a new log_id).
I am adding a View into the dataset to use for another report, which uses the same table but filters out some companies. The 'RegistrationLog_id' will have the same numbers and rows per company as the current table in the dataset, but would I need a relationship between these tables? Would it be one-to-one? Or possibly bad data modelling? Thank you.
I would not create a relationship. I would not even add this second table if it is strictly a subset of the first. If you need to create a visual off of it, simply filter the visual (at the visual or page level).
Why have two copies of the data? That's "Department of Redundancy Department" 🙂
Proud to be a Super User! | |
Can you show us some sample data? Sounds like Table 2 is simply a subset of Table 1?
Proud to be a Super User! | |
Hi @ToddChitt , sorry I cannot show sample data, but yes the new table is a subset of the original table (almost like a calculated table I believe?) Thanks
Can you MAKE UP something for us to see? Objuscate the crap out of it:
Table 1:
Company Log ID
====== =-===
1 101
1 102
??
Proud to be a Super User! | |
Hi @ToddChitt, no problem, please see the below.
It is near enough identical, whereby companies are filtered out for their status, and belonging to a region from another database (right join). The latestreg is just a partition by company id for numbering the latest registrations. I hope this helps, thank you
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
86 | |
84 | |
77 | |
49 |
User | Count |
---|---|
160 | |
144 | |
103 | |
74 | |
57 |