Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
anonymouAsd
Frequent Visitor

Apply Changes from Query Editor taking too long

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.

2 REPLIES 2
amitchandak
Super User
Super User

@anonymouAsd , if you are using dataflow then your system memory does not matter. You should move all steps to dataflow

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.