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

 

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's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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. :smileyhappy:

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