Forum Discussion

PeterB80's avatar
PeterB80
Regular Visitor
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
Microsoft Employee
8 years ago

Hi PeterB80,

 

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