Forum Discussion
Mobile Reports SQL 2016 vs. Power BI - duplicate values table relationship
kaarel Similiar that they both have the ability to create reports, but outside that these are vastly different tools.
Power BI leverages the same technologies used in SSAS Tabular models...essentially they are the same. This allows you to consume a much larger set of data to see everything, not just small snapshots, so it requires that you follow the current capabilities and rules in building that model.
Different tools for different aspects of your data and reporting needs.
You sound like you have already figured out the solution of just creating a dimension with a unique list of product keys and any metadata. You can than create a relationship from that unique dim to both the tables.
kaarel Similiar that they both have the ability to create reports, but outside that these are vastly different tools.
Power BI leverages the same technologies used in SSAS Tabular models...essentially they are the same. This allows you to consume a much larger set of data to see everything, not just small snapshots, so it requires that you follow the current capabilities and rules in building that model.
Different tools for different aspects of your data and reporting needs.
You sound like you have already figured out the solution of just creating a dimension with a unique list of product keys and any metadata. You can than create a relationship from that unique dim to both the tables.