Forum Discussion
Analyzing Big Data
I have a dataset, containing products and categories (it is an example). There are tens of millions of products and thousands of categories. Every product has a category and other columns with a...
Is it possible that PowerBI doesn't support filtering on SQL server side when there is a 1:1 relationsip?
For example, there is one to many relationship between Categories and Products and one to one relationship between Products and ProductsDetails.
User selects a category.
Expected behaviour:
- PowerBI filters Products by the category;
- using CompositeKey from filtered products, it loads data from ProductsDetails table (1:1 relationship).
Current behaviour:
- PowerBI loads data from ProductsDetails table for products from all categories and fails.