Forum Discussion

sfeki's avatar
sfeki
Regular Visitor
4 years ago

Schedule Refresh Power BI Service Issue

Hi Community, I'm facing the below error when trying to schedule refresh on Power BI service :    This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Po...
Need Help
Show and Tell
ibarrau's avatar
ibarrau
Super User
4 years ago

Hi sfeki! This usually happen because power bi has trouble deducing a single source for the url. Web.Contents has many parameters to help us get close to a url that make easy for power bi to understand it. The idea is to use the arguments RelativePath or Query. For example at your code:

Web.Contents(
    JIRA_URL,
    [
        RelativePath = "/rest/api/2/search",
        Query = [ jql = QUERY ]
    ]
)

That way the main jira url will be interpreted as source for PowerBi and the other changes as conditions but not dynamic source.

You can read more about this at: https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/

I hope that helps,