Dynamic Source in Report Doesn't Allow for Schedule Refresh

[filiparibeiro]

Hello.

I'm importing data from JIRA API in PBI as follows: https://community.powerbi.com/t5/Desktop/Get-Data-from-JIRA-API-and-import-in-Power-BI-with-Paginati...

When I try to schedule refresh in pbi service I get a notification saying it's not possible to do it because the report contains a dynamic source.

What can I do to workaround this issue?

Thanks in advance.

[ibarrau]

Hi. If my suggest doesn't work you might need to show us more about the power query code. Usually a dynamic source is a source that can't find an unique direction. That's something that happens with Web.Contents when calling apis or requests. The way to let power bi understand that the request is only one, it's defining a relativepath to keep a unique url as the parameter. Check the following post out
https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i...

I hope that helps,