The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I am trying to create a new fact table referencing from an existing table. I am trying to apply many changes and it is taking hours to complete. Even just applying the query when all I have done is reference my Fact table takes almost an hour. What could be causing it to take so long to just reference the table.
Note:
My data is about 150,000 rows by about 80 columns. I am using a dataflow that takes this data and transforms and cleans it which I then use in my report.
My specs are 16GB RAM, with an i7 core.
@anonymouAsd , if you are using dataflow then your system memory does not matter. You should move all steps to dataflow
@amitchandak I cannot move to all dataflows as the dataflows are provided by a thrid party and are automated. I need to read the dataflows and make my reports from there. I have many old fact and dimension tables that I am trying to use to make a new table, but this is taking a long time.