Skip to main content
cancel
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.

Reply
id013
Helper V
Helper V

Data Model Refresh Issue

Hi,

So I'm having an issue with a data model that has a SQL server datasource and 8 excel files as data sources located on a network share that is accessible by the gateway. When I do a refresh on PBI desktop on my local PC it takes 5-10 minutes to refresh which was acceptable. However, I found that when I deployed it to the production workspace and did a refresh there it would take 90 minutes. 

Has anyone run into similar issues before? I'm currently looking through the gateway logs but I thought I'd put the question out there.

Thanks

2 REPLIES 2
edhans
Super User
Super User

A ton of factors come into play:

  1. network latency
  2. gateway config
  3. machine gateway is installed on
  4. network issues

You can start with performance tuning at Monitor and optimize on-premises data gateway performance | Microsoft Learn



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

So there's another wrinkle with this issue. So I was getting errors refreshing the model on the service. Specifically I was getting a timeout issue on a specific table, I thought it was a related so I checked the model on PBI desktop to check if it would refresh there. I found that it also failed refreshing the table on desktop. But here's where it gets wierd, I grab the query for the table and run it on SMSS, works fine results return in like 2 seconds, 6200 rows. So same query on PBI desktop fails with timeout issue just like the refresh. If I adjust a table name in this case it's "pre_t" by adding another underscore to "pre__t" and it refreshes successfully with no issue. Is there any reason why making this change would even make a difference? 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors