101 Question for Data Modeling

[Anonymous]

Hello All,

I am a newbie in this area and just need some 101 help. I inherited a PBI report that pulls 10 tables from SQL. I can see the tables and spider web of relationships in PBI Desktop (data model). The original developer set up the report where 3 of the 10 tables are used to feed the report. If I try using fields from any of the other tables, I mainly get garbles inaccurate info. I just want to confirm my hunch, when tables are set up with relationships, it does not necessarily mean you can then pull from any table, the end result of the design will be designated tables intended for use. Is this a correct assumption? The previous developer is gone and I am not a database person but seem to understand the fundamentals. Thanks for any help with this question.

[harshnathani · Accepted solution]

Hi @Anonymous ,

Go thorugh the documentation and this free course by SQL BI on Data Modelling.

Will help you understand Data Modelling better

https://www.sqlbi.com/training/data-modeling/

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You could accept some courses from this link:

https://docs.microsoft.com/en-us/learn/modules/model-data-power-bi/

[harshnathani · Accepted solution]

Hi @Anonymous ,

Go thorugh the documentation and this free course by SQL BI on Data Modelling.

Will help you understand Data Modelling better

https://www.sqlbi.com/training/data-modeling/

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous , Too broad question, can you be specific. Can you share sample data and sample output in table format?