I need to do left joins in my data model in Power BI. I import my model from SQL Server where I have one big fact table with multiple relationships to dimension tables. Power BI only allows me to do inner joins which allows me to put to my report only one type of fact, when I want to put other type of fact, I would need left join? Someone having same issues or any experiences how to do left joins in Power BI?
Asked
Active
Viewed 141 times
1 Answers
1
It seems from your comments your data is modeled in a Attribute-value pair style. I would create 3 filtered Queries in the Power BI model to split the Fact table data by Category.
With those 3 tables in place in the model, I would create relationships from each Fact-based table to the Contract table. Then Power BI will naturally return all the Interest rates, Residual values and Prices data for each Contract.
Mike Honey
- 2,632