Forum Discussion

JohnM1985's avatar
JohnM1985
Regular Visitor
2 years ago

Help with database structure OR relationship schema!

Hi, I'm attempting to create a repository of all my teams Power Bi reports, showing all of the datasources, and all of the notebooks which are used to populate these data sources.   Part of my chall...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

JohnM1985 , I think split by delimiter into rows, is the best solution for this problem for table 1 and Table2, and if needed for Table 3 too

 

Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag

JohnM1985's avatar
JohnM1985
Regular Visitor
2 years ago

Thanks amitchandak ,

The problem that this seems to bring is the relationships between the tables, as table 1 goes from:

ReportNameDataSource
Rep1DS1, DS2, DS3
Rep2DS4
Rep3DS1, DS5


To:

ReportNameDataSource
Rep1DS1
Rep1DS2
Rep1DS3
Rep2DS4
Rep3DS1
Rep3DS5


But I don't want that to display with multiple names (i.e. Rep1's) to the user - so I can build a relationship from my original table, to the delimited one, but then to connect this to the next tables I end up with a many-many relationship which I'm trying to avoid, or by using bridging tables with 1 to 1 relationships, which doesn't seem to work.... I wondered if there was a more creative way to get to my solution