Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power bi Assistance.

Good afternoon All,    I'm new to Power bi, and i've taken the power bi black belt series courses (all 4), however i think i haven't fully gotten the grasp of the power bi.    I'm requesting some...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago
Hi Anonymous,

What type of insights do you need?
What are your doubts? Your concerns?

Being PBI a self-service BI you can have the hability to have fully detailed or aggregated information helping you get a 360 view of your data.
But this is the generic information that you have read for sure.

Regards,
MFelix
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    okay so i have a very large data set that i'm trying to set up. i'm still not confident on the relationships yet. here goes. None of my tables were automatically set up from power bi. so i've have to do them manually. most work with many to many but it's not reading all of the data, hence i've started to do the work around with tables with uniques values, HOWEVER this is where i'm getting stuck. 

     

    What would need from me to assist? screen shots?

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      7 years ago

      Hi Anonymous ,

       

      The best way is to post some sample data, expected results, questions you have.

       

      Please see this post regarding How to Get Your Question Answered Quickly:
      https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).

       

      Since this already as every aspect refered I don't have to rewrite.

       

      :smileyvery-happy::smileyvery-happy::smileyvery-happy::smileyvery-happy:

       

      If you want to share some sample data you can do it trough a onedrive, google drive, we transfer type of link.

       

      Hope you can send it  as soon as possible,

       

      Regards,

      MFelix

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        due to HIPPA laws i can't reveal my data. but i can advise what i'm trying to do. i need to connect my client master to all of these tables. below. i believe doing the manual tables is the best to go since i began. creating unique identifiers in each table is my hunch. but there's alot of tables so i'm thinking of different methods and trying not to go down the wrong path. 

         

        having trouble post my data example. copy and paste doesn't seem to work. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Anonymous ,

      I think bridge tables should help for your scenario, it can help you to mapping different table records more accurately.
      You only need to extract same type fields(e.g product id, user id,etc...) from different tables and remove duplicate to use it as bridge to create one to many relationship to link these tables.

      DAX Puzzle: Multiple many-to-many relationships

      HOW TO JOIN MANY TO MANY WITH A BRIDGE TABLE IN POWER BI

      Please understand that these links are provided with no warranties or guarantees of content changes, and confers no rights.

      Regards,

      Xiaoxin Sheng