cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lekkerbek Regular Visitor
Regular Visitor

Close and apply takes a long time

Hi,

 

I have a power BI file with data in it. From an outside source I imported the sales from 2014 to 2017 YTD into seperate tables.

 

I then append those queries t to a new a new table. The idea was that I only have to refresh the 2017 table rather than all the older years.

 

That took a long time, but was finally done. 

 

I forgot to change 2 column names so when I edited those I had to apply them once again.

 

Is it normal that it takes the same amount of time as the first time if I just change 2 column names? I'm talking about hours here. Is there a way to speed up that process?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
v-jiascu-msft Super Contributor
Super Contributor

Re: Close and apply takes a long time

@lekkerbek

 

Hi,

 

Your table could be very big. The cause may be this. You changed the column names of original tables (sales 2014 ……) other than the appended new table. So Power BI will do “append tables” again when you apply. (You can see it in the picture in the bottom. I just changed the name of a column in sales, but the appended new table applied the changes totally.) The Query Editor just edit the queries. Power BI will perform it when you click “Apply”. If tables are too big, it will cost time. But we can avoid doing it twice. Please refer to the steps below.

  1. Upgrade Power BI to the newest version from here: https://powerbi.microsoft.com/en-us/desktop/
  2. If you change column names here, it will be better (showed in the pic).
  3. If you want to refresh, refresh here will be betterClose and apply takes a long time .jpg
Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Highlighted
v-jiascu-msft Super Contributor
Super Contributor

Re: Close and apply takes a long time

@lekkerbek

 

Hi,

 

Your table could be very big. The cause may be this. You changed the column names of original tables (sales 2014 ……) other than the appended new table. So Power BI will do “append tables” again when you apply. (You can see it in the picture in the bottom. I just changed the name of a column in sales, but the appended new table applied the changes totally.) The Query Editor just edit the queries. Power BI will perform it when you click “Apply”. If tables are too big, it will cost time. But we can avoid doing it twice. Please refer to the steps below.

  1. Upgrade Power BI to the newest version from here: https://powerbi.microsoft.com/en-us/desktop/
  2. If you change column names here, it will be better (showed in the pic).
  3. If you want to refresh, refresh here will be betterClose and apply takes a long time .jpg
Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lekkerbek Regular Visitor
Regular Visitor

Re: Close and apply takes a long time

Thanks, that makes sense.

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 121 members 1,620 guests