March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
134 | |
91 | |
89 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |