Forum Discussion

mizzoudavis's avatar
mizzoudavis
New Member
10 years ago

Connecting to Web services via Power BI Service

Using Power BI Desktop I've successfully connected to a web data source via an API query (Teamwork.com) that I'd lke to analyze. Specifically, however, I need this data to refresh daily and to be viewable by my work group (0365 environment). The content is not available in one of the service packs listed on the Power BI Library which is discouraging... 

 

Is there any way to do what I'm trying to do within the confines of Power BI? If so, what combination of services/gateways, etc will I need in order to see daily refreshed data directly from Teamwork.com without needing a manual refresh + publish?

2 Replies

  • ankitpatira's avatar
    ankitpatira
    Community Champion

    mizzoudavis Once you publish report to power bi service, go to dataset settings, sign in under data source credentials and then setup daily schedule under Schedulre Refresh. Since you're using online data source you don't need any gateways.

    • mizzoudavis's avatar
      mizzoudavis
      New Member

      Thanks for your reply!  I do not see a data source credentials under the data set settings. Is this a feature that's native to a certain account level?