Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
118 | |
75 | |
46 | |
44 | |
34 |
User | Count |
---|---|
180 | |
85 | |
68 | |
47 | |
46 |