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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DebbieE
Community Champion
Community Champion

Dataflows and refreshing to check changes

I have created a dataflow

 

Every time I do any small developments and then go back to Desktop to refresh, the new column comes through but it doesnt have any data in it.

 

I have to go back and refresh in Service but it takes about an hour to refresh. This is really causing me issues when i am trying to check quick changes. Its taking me ages to do anything. 

 

Is there any tips you can give me for avoiding the refresh times when I just for example do a tiny amendment on a column

1 ACCEPTED SOLUTION
v-gizhi-msft
Community Support
Community Support

2 REPLIES 2
v-gizhi-msft
Community Support
Community Support

When you do joins/appends in Power Query it has to load the entire table into virtual memory. This causes a lot of paging and is very slow.

 

That will do it then. Im trying to get everyone to move towards a proper data model in a SQL database. Hopefully this is another reason for it

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors