Microsoft-Certified Power BI REST Connector Now Available!

Thanks for sharing the update ​@Everton Colling . This is an awesome update to the existing version and will help us solve a lot of limitations.

Thanks for getting a new version out there and documenting it. Excited to test this out!

​@Everton Colling  Are incremental refreshes supported with the new REST connector?

Hi ​@Anders Brakestad! Yes, incremental refresh can be set up using the new REST connector, as long as the resource/endpoint you are trying to fetch supports server side filtering on a time range.

The way Microsoft enabled this feature is a bit complex, but you should be able to accomplish it by following instructions here: https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview. There’s even an example fetching data from a REST endpoint using Web.Contents that would be very similar to what happens with the REST connector which uses this function under the hood.

Be mindful that, different than OData, for REST endpoints, if you pass a filter that results in no data, an empty Table without any columns/properties would be returned. For Power BI service to join tables using incremental refresh, a given Power Query table needs to always return the same schema (list of columns). That means you need to do maintain a list of columns/properties you are interested to fetch from a given endpoint an make sure the Power Query code would always return these columns. I’ll try to work on adding a tutorial with some examples to our public documentation in the coming weeks to help users setup this functionality using the new connector and REST endpoints.

Great, thanks for the quick reply!