Web Datasource refresh issue (web.contents)

[Anonymous]

Hi,

Iam getting the following error "You can't schedule refresh for this dataset because the following data sources currently don't support refresh:

• Data source for Query1

 When i publish the report to power bi service, im facing this issue and in power bi desktop it works well.I have referred to following blog Chris Webb blog: https://blog.crossjoin.co.uk/2016/08/.

But Nothing helped me. Iam unable to fix this. I need to use the relative path and Query parameters for the following code

Source = Json.Document(Web.Contents("https://nam.api.newvoicemedia.com/stats/agent-activities/interactions?end="&Date.ToText(EndDate, "yyyy-MM-dd")& "T23:00:00.000Z"&"&start="&Date.ToText(StartDate, "yyyy-MM-dd")& "T00:00:00.000Z"&"", [Headers=[Accept="application/vnd.newvoicemedia.v3+json", Authorization="bearer "&GetAccessToken()]])),

Any help is appreciated.

thanks

[akashgera]

Hi @v-jingzhang 

I need your help in executing the below query which will generate the access token using power query.

After executing the above query it throws as error: webcontents failed to get contents from the given URL

Doing the same in Postman and giving the proper response, check the screenshot below

Pls help!!

[v-jingzhang · Accepted solution]

Hi @Anonymous 

I can't test this but maybe you can try below codes:

Source = Json.Document(Web.Contents("https://nam.api.newvoicemedia.com/stats/agent-activities/interactions",
[
Query=[end=Date.ToText(EndDate, "yyyy-MM-dd")& "T23:00:00.000Z", start=Date.ToText(StartDate, "yyyy-MM-dd")& "T00:00:00.000Z"],
Headers=[Accept="application/vnd.newvoicemedia.v3+json", Authorization="bearer "&GetAccessToken()]
]
)),

Or 

Source = Json.Document(Web.Contents("https://nam.api.newvoicemedia.com/stats/agent-activities/interactions?end=2021-01-01T23:00:00.000Z&start=2020-12-01T00:00:00.000Z",
[
Query=[end=Date.ToText(EndDate, "yyyy-MM-dd")& "T23:00:00.000Z", start=Date.ToText(StartDate, "yyyy-MM-dd")& "T00:00:00.000Z"],
Headers=[Accept="application/vnd.newvoicemedia.v3+json", Authorization="bearer "&GetAccessToken()]
]
)),

Reference:

API Pagination + Throttling + Dynamic data source ... - Microsoft Power BI Community

Dynamic Web.Contents() and Power BI Refresh Errors – Data Inspirations

Regards,
Community Support Team _ Jing

[Anonymous]

Hi,

there was small mistake in my code and it works now, the data source refresh error gone now. 

Thank you so much 🙂

But one thing is datasource credentials are greyed out in power bi service 

and under parameters section -> if i change the start and end date value and click apply. nothing happens..

Do you have any idea about this

Your help is much appreciated.

[Anonymous]

Hi,

Datasource refresh error gone now in PBI service. But Datasource credentials and schedule refresh are faded out.

Do I need to install gateway to use the Web API datasource.

If yes, Do we have to use on premise gateway or Personal ?

kindly let me know what should be done to fix this.

any help is appreciated

[v-jingzhang]

Sorry for the late reply. If only this Web API data source is included in the report, it is not necessary to install an on-premises gateway.

I see you have solved this problem, can you share the final solution you found? This may help other users who have similar problems in the future. Thanks.

[Anonymous]

Hi

The issue not resolved until i install the personal gateway. Once installed, i skip test connection for all apis and im able to do schedule refresh the dataset.

Thanks

[Anonymous]

Hi,

I have tried your code, it works when i pass the parameters in function before "let" in the code. 

And when i include the below code, the entire table changed to function. Iam using this table with other tables for joins. So others are not working.

(StartDate as date,EndDate as date) =>
let
Source = Json.Document(Web.Contents("https://nam.api.newvoicemedia.com/stats/interactions",
[
Query=[end=Date.ToText(EndDate, "yyyy-MM-dd")& "T23:00:00.000Z", start=Date.ToText(StartDate, "yyyy-MM-dd")& "T00:00:00.000Z"],
Headers=[Accept="application/vnd.newvoicemedia.v3+json", Authorization="bearer "&GetAccessToken()]
]
)),

I have two parameters created, startDate and endDate and i directly passed the parameters inside the url like this before :

Source = Json.Document(Web.Contents("https://nam.api.newvoicemedia.com/stats/agent-activities/interactions?end="&Date.ToText(EndDate, "yyyy-MM-dd")& "T23:00:00.000Z"&"&start="&Date.ToText(StartDate, "yyyy-MM-dd")& "T00:00:00.000Z"&"", [Headers=[Accept="application/vnd.newvoicemedia.v3+json", Authorization="bearer "&GetAccessToken()]])),

So there is no impact , the table remains the same and joins works with other tables.

But the thing is the I need to use the query parameter and relative path to publish in service without any error.

Please find the screenshots below

Kindly help me. 

Regards