100 GB data on AWS Workspace

Hello,
An update on the same:
I tried various aggregations and simplifications to my query, however have been getting this error: MySQL: Fatal error encountered during command execution. 
I have tried indexing the columns, using window functions instead of group by ,etc. But only the basic queries like SELECT * FROM table works. The rest of the queries with aggregation or partitioning ,etc fails.

Did you create a view in the database?

No. 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

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.

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). 

Hi SaiK,

Have you tried to execute a stored procedure to create a new table with the aggregation data  and then get the SELECT * from that new table?

Hi Felix,
After having a discussion with my team, turns out we will have to build a ETL pipeline to extract the data, peform some transformations on it prolly on DBT and then load the data to Power BI.