Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

aleksandrama

Dataflow refresh very slow

Submitted by on ‎02-15-2022 12:52 AM

yesterday and today im experience Dataflow refresh very slow, it takes already a couple of minutes, normaly it takes a ferw secounds. is there any outage today ??

 

aleksandrama_0-1644914227272.png

 

loading the table in Dataflow is also very slow, it takes 1,5 minutes 

 

Status: Investigating

Hi  all,

 

Please check whether the data amount refreshed quite large so it caused the long time refresh. If your model is very simple, please try to refresh your dataflow with on-demand refresh to see whether you will have same issue or whether this issue is happening at a relative fixed time.

If your dataflow refresh issue is not caused the above reasons and you are a Pro user, please consider getting direct help from the technical team of Microsoft by support ticket. They will have a remote session with you to troubleshoot on this issue.

For how to create a support ticket, please refer to this blog: https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

Power BI Support: https://powerbi.microsoft.com/en-us/support/

 

It couldn't be better if any of you post the root cause and solution of such issue here once you get them from technical team to help others who may encounter similar issue. Thanks in advance!

 

Best Regards,

Community Support Team _ Caiyun

See more ideas labeled with:
24 Comments (24 New)
Comments
joannm
Frequent Visitor
‎02-17-2022 05:59 AM

This is not something that will be handled via a one-off support ticket.

 

Data flows as currently configured are unusable. Regardless of the size, unless you're talking hundreds of tables and millions of rows, it should not take an entire day to save. Ever. Much less for one tiny change. God help you if you had a typo.

 

I can't report to the management team that simply adding a single field to their report will take an entire day to update. Sticking your head in the sand or pointing to a shiny support ticket over there won't make that acceptable.

 

MS can either fix it, or we'll all find another tech to use.

 

It's that simple.

 

I'm already looking. An internal Postgres db will be more work sure, but cost me almost nothing and will certainly perform better. But I'm checking other options as well.

kevingauv
Advocate II
Advocate II
‎02-21-2022 07:37 AM

Same issue here ( Canada Central).

Got issue with Dataflow refresh that normally finish in seconds and now, they took hours or they do not finish.

 

Is it possible that the last Gateway Update (3000.110.5)  is the cause ???

smpa01
Super User
Super User
‎02-23-2022 06:04 AM

Dataflow capabilities are restored and working as desired now.

croberts21
Responsive Resident
Responsive Resident
‎03-23-2022 05:19 AM

We now use an SQL statement for the initial selection of records, with an ODBC data source. Do these steps: 

- Go to Get Data. Use an ODBC data source.

- A popup window should appear. Choose your data source. Click the arrow next to Advanced. 

- A box should open up where you enter in your SQL statement

- Using the SQL statement you can select all records or limit by date or other criteria. 

- Ex: SELECT * FROM customer

- No trailing semi-colon is needed here.

Now use Transform to choose only columns you want. Chooseing less columns helps reduce Refresh time.

 

croberts21_0-1648037883767.png

 

Idea Statuses