powerbi - I need to get a value from a sub table from a Power BI Semantic Model - Stack Overflow

admin管理员组

文章数量:1384189

Due to confidentiality, I've changed (and simplified) my scenario. My work has a Power BI semantic model. In that model there a 3 relevant tables for my problem. A person table, with a staff ID and name attributes, a training table, with a training code and title attributes, and a status table, which just shows a status for the training - a single attribute. There are hidden attributes and tables in the model that I can't change (and in the real model, not my simplified version, there are many tables in between the relevant tables here, they aren't direct connections). There are appropriate relationships between the tables in the model so that when I create a table with the staff ID and training code, I can include the correct status in the same table. e.g. Bob attended training 1 and the status is failed. The part I need help with is that I have a spreadsheet of staff that were caught cheating. My spreadsheet contains the staff ID and training code, and I need to get the matching status from the semantic model. Behind the scenes in the model I know that there are surrogate keys and hidden attributes, but I'm not able to use those. I can create a relationship between my spreadsheet staff id and the person table, and also create a relationship between my spreadsheet training code and the training table, but only have 1 of those relationships active at a time. How can I use the staff id and training code from my spreadsheet to get the status that I need?

本文标签： powerbiI need to get a value from a sub table from a Power BI Semantic ModelStack Overflow