Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

SQL aggregation for Direct Query

Hi,   I need to import the Historical Inventory table, which consists of sales data through item, Item variant code, location and day and for the measures, I need the most detailed information that...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks, Anonymous 

I know about this feature, but with basic information that I need with SQL statement still, I get 40 mln rows.

 

I know I can aggregate separate tables by item, by location, by date, but then I won't be able to calculate let say, sums by item for a particular period (days) for a particular location. If I divided information by month there will be extra steps every month that must be done, in order for the report work correctly and I'm preparing the report for the client it's not very suitable for them.

 

I'm in big doubt if Power BI able to work efficiently with large data quantity?