topic Re: Incremental refresh to Power BI with custom connector from API Rest source in Developer

Incremental refresh to Power BI with custom connector from API Rest source

Anonymous — Thu, 09 Feb 2023 09:33:53 GMT

Hi, we saw this code sample from the Incremental refresh documentation:

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#supported-data-...
this code used remote (Source API Rest data) source with the RangeStart and RangeEnd , when we try to do that with a custom connector we can’t get access to these Managed parameters.
is there a way do this Incremental refresh with a custom connector and make?

Re: Incremental refresh to Power BI with custom connector from API Rest source

jaweher899 — Thu, 09 Feb 2023 12:56:57 GMT

it is possible to do incremental refresh with a custom connector in Power BI. The custom connector should support incremental refresh by providing the necessary information such as the range start and end values, so that Power BI can determine which data to retrieve during the refresh operation.

To implement incremental refresh with a custom connector, you would need to add the appropriate logic in your connector code to retrieve the necessary data based on the provided range start and end values.

For example, if your custom connector is using an API to retrieve data, you would need to add parameters to the API call to specify the range of data to retrieve based on the provided range start and end values. The API should return only the data that falls within the specified range, which will then be used for the incremental refresh in Power BI.

Re: Incremental refresh to Power BI with custom connector from API Rest source

LiranRom — Thu, 09 Feb 2023 14:23:12 GMT

Thanks for your answer,

Can you please give an example or link to an example that shows how to add this "appropriate logic in your connector code to retrieve the necessary data based on the provided range start and end values"

Our connector get no parameters from outside, just a JSON token for the authorization

and it has a API call we perform to server that has range time parameters (start and end time)

the question is how to connect between the URL we use in the Wenb.Content(URL) and the powerbi RandeStart / RangeEnd parameters

meaning: we are edit the connector code in VisualStudio. if I will write RangeStart and try to use it as a parameter in the URL - the code won't compile and it does not know what is RangeStart (it is undefined param)

Thanks,

Re: Incremental refresh to Power BI with custom connector from API Rest source

Anonymous — Thu, 09 Feb 2023 15:24:07 GMT

jaweher899
what are the necessary information and how does it work, we don’t have access to managed parameter with the connector, and this is the only thing the documentation says that we need to do

Re: Incremental refresh to Power BI with custom connector from API Rest source

Anonymous — Tue, 14 Feb 2023 15:56:27 GMT

jaweher899 ?