Data Modeling: Creating Correct Primary Keys/Secondary Keys

[Yrstruly2021]

I created a relational model in Powerbi with this data:https://drive.google.com/file/d/1ggsyn9iOfwVJGZPBz9aNfQ6aXBYBH61V/view?usp=sharing 

I managed to link relationships in Powerbi, but my data does not show when i pull in from more then one source table in Powerbi.

Please assist, what am i doing wrong?

PBIX:https://drive.google.com/file/d/1CBpFLkw37E5aeYSG9RXMLTzOXUCdcn4m/view?usp=sharing 

[v-henryk-mstf · Accepted solution]

Hi @Yrstruly2021 ,

For the connection field Holiday_ID of the Invoice table and the PHoliday table, the field Holiday_ID of the Invoice table is null, so it cannot be a correct connection relationship. So it will cause the above display to be empty.

If the problem is still not resolved, please provide detailed error information and let me know immediately. looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Yrstruly2021]

Please assist, creating and connecting relavent columns to invoice table?

[jdbuchanan71]

There are no Holiday_ID on your Invoice table so there is nothing for the PHolidays table to match.