Creating Custom columns

Hi , 

Yes, Power BI can handle large datasets and create 200+ custom columns, but it may lead to performance issues like slow refreshes and heavy model size. To manage this effectively, preprocess the data using tools like SQL, Dataflow,Azure Data Factory to create custom columns and streamline the dataset. In Power BI, focus on key metrics by aggregating data quality insights and avoid overloading the model with unnecessary calculated columns. Use Import Mode with optimized columns or DirectQuery if transformations are handled externally. This hybrid approach ensures scalability and better performance.