Forum Discussion

sahilhira162's avatar
sahilhira162
Helper I
9 years ago

Unable to refresh Data using Power BI Online,

Hi,   I have created a report which is intergated with Wrike and Excel, they extract data from Wrike and Excel. It works fine on Power BI desktop but when I try to refesh using Power BI Online it d...
Need Help
sahilhira162's avatar
sahilhira162
Helper I
9 years ago

Hi v-ljerr-msft

I am looking for information to install the data gateway now, but instead of personal gateway, I want to install an enterprise gateway. Is there any link or information regarding that.

Thanks in advance.

Regards,
Sahil

sahilhira162's avatar
sahilhira162
Helper I
9 years ago

Also, I have created a personal gateway for power bi. It is giving error "Your data source can't be refreshed because the credentials are invalid". Data source credentials I am using are: -
url - "wrike api path" 
Authentication method - "Anonymous" (used basic login method as well, where I entered my office 365 userid password using which I login wrike)
but that gave the same error.

Regards,
Sahil

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi sahilhira162,



    Also, I have created a personal gateway for power bi. It is giving error "Your data source can't be refreshed because the credentials are invalid". Data source credentials I am using are: -
    url - "wrike api path" 
    Authentication method - "Anonymous" (used basic login method as well, where I entered my office 365 userid password using which I login wrike)
    but that gave the same error.

    You need to update the credential on Power BI service Datasets Settings after the report has been published. And he authentication methods on Power BI Desktop and Service have to match, or the refresh won't work.

     

     

    In addition, you can follow this article to install the enterprise gateway. After the enterprise gateway has been installed, you will need to follow this article to manage your data source on Power BI service for Scheduled Refresh. :smileyhappy:

     

    Regards