Forum Discussion
Helper IIIncremental refresh for Jira Data
Hello All,
We use connectors to bring in the data from Jira in Power BI using Odata. The issue with this is that we are not able to use incremental refresh in our dataset and so the refresh takes way longer that it should. Can someone help me configure the Incremental refresh for our scenario or other options like creating custome connectors and using Table.View to do it.
Below is what our query looks like:
let
Source = OData.Feed("Connector URL", null, [Implementation = "2.0"]),
#"Navigation 1" = Source{[Name = "Table Name", Signature = "table"]}[Data],
#"Remove columns" = Table.RemoveColumns(#"Navigation 1", Table.ColumnsOfType(#"Navigation 1", {type table, type record, type list, type nullable binary, type binary, type function})),
#"Changed column type" = Table.TransformColumnTypes(#"Remove columns", {{"ISSUE_UPDATED", type datetime}})
in
#"Changed column type"
Thank You!!
RangeStart is a Power Query parameter, not a field in Jira. Your Query string is malformed. You will want to use the Query parameter anyway. Please read the documentation again.
You can also read this article. Using OData.Feed and the Query option to avoid the dynamic data sources error in Power BI (crossjoin.co.uk)
7 Replies
- lbendlin
Super User
RangeStart is a Power Query parameter, not a field in Jira. Your Query string is malformed. You will want to use the Query parameter anyway. Please read the documentation again.
You can also read this article. Using OData.Feed and the Query option to avoid the dynamic data sources error in Power BI (crossjoin.co.uk)
- lbendlin
next step is to create two datetime parameters RangeStart and RangeEnd, and to use them as filters in your query. Ideally directly in the ODATA query as otherwise you won't have any performance gains.
