Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
BotBot1
Helper III
Helper III

Relationship Needed?

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.

5 REPLIES 5
ToddChitt
Super User
Super User

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" 🙂

 




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





ToddChitt
Super User
Super User

Can you show us some sample data? Sounds like Table 2 is simply a subset of Table 1?




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

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

 

??




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





Hi @ToddChitt, no problem, please see the below.

BotBot1_0-1692103795001.png

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.