Forum Discussion
Unable to refresh Data using Power BI Online,
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
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? :smileyhappy:
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
Regards
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,
SahilHi 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