Forum Discussion
Optimize Query with data calculations
I have a database which is grouped by sales data per location, month, product_id and sales_segment. The thing is I want to compare previous year's sales data, where normally using SQL I would creat...
Hi Otavio_Hurtado - 500 million rows will be okay as long as the Cardinality of the Foreign Key dimension columns are small, so don't load too many unique values!! In the example above, if you have a Row ID for each transaction, then remove it and aggregrate in SQL before loading to Power BI (add a Count of Transaction Rows)
You may want to consider limiting the history in query to reduce size. And consider incrementally loading data improve load times.