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