Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Large Datasets - How can I improve performance?

Hi   My organisation is using PowerBI on SQL with an Oracle data cube. It is used in multiple businesses and as such there are data fields which contain very large datasets which currently make the...
Large Dataset Problem
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Are “BT Customer Name”, “BT Sales Agent Name”, “Sales Rep Name”,  “Full Name” and “Product Family Code” field names in a same table? If so, to filter records, you can directly filter “Product Family Code” field in Query Editor mode.

 

Under the list of the column you want to apply filters, only select those values you want to reserve. Similar to:

 

Regards,

Yuliana Gu