Forum Discussion
Helper I100 GB data on AWS Workspace
Pre-aggregate means to summarize the data using GROUP BY instead of loading all rows. For example instead of loading by transaction id or transaction lines, group the rows by a certain column.
Ohh yess, that is something I could do. Instead of applying the measures after importing shall apply GROUP BY before importing. Thanks a lot!!
Super UserDid you create a view in the database?
Helper INo. Should I create one? How should I go about this issue? Any bit of complexity I add to my code and it gives me the error
- danextian
This is a sample script:
CREATE VIEW ProductCategoryView AS SELECT p.ProductID, p.ProductName, p.CategoryID, c.CategoryName FROM Product p INNER JOIN Category c ON p.CategoryID = c.CategoryID;Note: Different databases will have different syntaxes so this
This wil create ProductCategoryView view and instead of connecting to the tables, you connect to this instead in power query.
- SaiK
I did try creating the view as you said, even that failed and gave me the same error. I have also changed the query timeout settings to limitless(0).