Unable to refresh Data using Power BI Online,

[sahilhira162]

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 doesn't refresh any data. It doesn't throw any error for the same.
Kindly suggest what to do. Any help is appreciated.

Regards,
Sahil

[v-ljerr-msft]

Hi @sahilhira162,

Have you installed the Data Gateway in order to refresh your dataset on Power BI service?

Could you follow this article to recheck the steps of installing and configuring a Personal Gateway to see if the refresh works in your scenario? 

Regards

[sahilhira162]

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]

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]

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. 

Regards

[sahilhira162]

Hi @v-ljerr-msft

I tried doing that only, but its not working. When I set up the personal gateway, and edit the data source credentials. 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)
that's giving me the same error "Your data source can't be refreshed because the credentials are invalid", which is strange because I use same credentials to refresh from Power BI desktop.

Regards,
Sahil

[v-ljerr-msft]

Hi @sahilhira162,

Could you post the Power Query you're using in the Query Editor > Advanced Editor? So that we can help further investigate on this issue.

In addition, following are some similar threads for your reference, could you go to check if it helps in your scenario? 

https://community.powerbi.com/t5/Service/Anonymous-access/td-p/19136

https://community.powerbi.com/t5/Service/Refreshing-a-Restful-Data-Source-with-API-Key/td-p/131298

https://community.powerbi.com/t5/Service/Cannot-sign-in-with-Anonymous-Authentication-for-a-Web-API/...

Regards

[sahilhira162]

Hi @v-ljerr-msft

Thank you for the links that you provided, they were really helpful. It seems that I have to used the relative path in my power query. Once I use the relative path, its not showing any error, but its not connecting to the gateway I have created. I am confused whether I did something wrong or Power BI doesn't need a gateway to connect to Wrike URL. Anyhow still unable to refresh data on Power BI Online, and works perfect on Power BI Desktop.

No error in data credentials but Gateway connection not using data gateway I created.
Power Query
let
Source = Web.Contents("https://www.wrike.com",
[Headers=[#"Authorization"="bearer API Key"],
RelativePath = ""/api/v3/folders/IEAA6OFNI4CQ5SOI/folders?project=true"]),
convertToJson = Json.Document(Source)

Thanks in advance.

Regards,
Sahil 

[v-ljerr-msft]

Hi @sahilhira162,

 I am confused whether I did something wrong or Power BI doesn't need a gateway to connect to Wrike URL.

---

This is the expected result. If your dataset only contains the Wrike online data source, then the gateway is not needed. 

Anyhow still unable to refresh data on Power BI Online, and works perfect on Power BI Desktop.

---

It seems to be the same issue in this thread. The solution mentioned there still requires the root url of the api works with anonymous access, or it won't work. Then the only workaround is to execute the query elsewhere (i.e. Google Spreadsheet) and connect PBI to that as a data source.

Regards