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

Data refresh issue

Hey Guys,

 

Hoping someone can assist pls?

 

I have created a SQL view which is sat in Azure, I then bring this view down into Bi desktop on Direct Query and create all my reports for there. All been working OK and I have other reports that are the same and working OK.

 

I'm having issues in the Desktop and the report just won't load and also once published the data just doesn't refresh and times out. Obviously the data set is getting large but it's still only circa. 2,500 rows of data, also I don't have any calculated fields as this is all being done in SQL.

 

I've recreated parts of the report from the same SQL view and not having any issues so I'm guessing this may be related to my Direct Query but don't know where to start?

 

Thanks in advance to anyone that could offer up advise, Toby

1 ACCEPTED SOLUTION

Accepted Solutions
Tucker Regular Visitor
Regular Visitor

Re: Data refresh issue

@v-huizhn-msft

 

Having visited the report again today the data is refreshing and seems to be OK in all apps, strange, that tech for you!!

 

Thanks for your help though

View solution in original post

4 REPLIES 4
Tucker Regular Visitor
Regular Visitor

Re: Data refresh issue

I have a little bit more info on this if anyone cn help pls? Similar post from last year 

 

https://community.powerbi.com/t5/Service/The-XML-for-Analysis-request-timed-out-before-it-was-comple...

 

Capture.JPG

 

Microsoft v-huizhn-msft
Microsoft

Re: Data refresh issue

Hi @Tucker,

Based on my understanding, you can get data from SQL Azure, and create reports in Power BI desktop, all the things work fine. While the data in SQL Azure has been changed, it returns error when you refresh data in Power BI service, right? If it is, please specify timeout interval in Power Query manually. And check if there still has the problem.

Right click your resource table-> Advanced Editor, add the timeout statement.

1.PNG

 

[timeout=#duration(0,0,30,0)], which is a TimeSpan like parameter, with the values representing Days, Hours, Minutes, Seconds.

Best Regards,
Angelia

Tucker Regular Visitor
Regular Visitor

Re: Data refresh issue

Thanks @v-huizhn-msft

 

I have applied as you say, however I get an error "Combining Direct Query and imported data isn't supported" is this something you have seen previously pls?

 

Cheers Toby

 

Tucker Regular Visitor
Regular Visitor

Re: Data refresh issue

@v-huizhn-msft

 

Having visited the report again today the data is refreshing and seems to be OK in all apps, strange, that tech for you!!

 

Thanks for your help though

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,283)