Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Azure DevOps via oData Not Refreshing Entire Dataset using Power BI Service Scheduled Refresh

So we are pulling data from Azure DevOps into Power BI via oData because that is the only way to bring "BoardColumn" into Power BI.   ADO has about 230 items in it, and when I refresh using Power B...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

How long did you set on you datasource? Maybe you can modify on timeout duration to increase refresh timeout:

 

Source = OData.Feed("http://some.url/service.svc/", null, [Timeout=#duration(0, 0, 15, 0)])

 

In addition, power bi has its timeout limitation on refresh data, you can consider to upgrade your license to premium to increase maximum of timeout.(default two hours)

Troubleshooting refresh scenarios#scheduled-refresh-timeout

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Happy to try that. I have probably like 3-5 odata queries, I'm assuming I need to add that to all of them?

     

    But don't I not want it to time out on the online service? If one fails, wont the entire refresh fail? To be clear, it refreshes on the desktop just fine (see all 232 items) but the online service is all over the place:

     

    • 142 a couple days ago
    • 9 yesterday
    • 70 today
    • 68 today (via Power BI App on iPhone...)
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Anonymous ,

      I also not so sure why these dataset refreshed so unstable. Perhaps you can open a support ticker to ask power bi team to trace detailed information and troubleshooting it.

      submit a support ticket

      Regards,

      Xiaoxin Sheng