Forum Discussion

Tucker's avatar
Tucker
Helper I
9 years ago
Solved

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 ...
Need Help
  • Tucker's avatar
    Tucker
    9 years ago

    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

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

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.

 

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

Best Regards,
Angelia

Tucker's avatar
Tucker
Helper I
9 years ago

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's avatar
    Tucker
    Helper I
    9 years ago

    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