Incremental Refresh in power bi desktop

[Anonymous]

Team, Datasource which is Servicenow on the cloud does not support query folding. I am trying to schedule an incremental refresh on this data in power bi. The data is coming into power bi using REST API.

Can anyone guide me on how I can achieve this using a power query on the desktop? I would be publishing this data model onto a workspace which is on premium capacity.

Thanka a lot in advance.

[antonstorozhuk]

Hello @Anonymous 

We've built an app for Servicenow and Power BI integration: Power BI Connector for Servicenow.

We're currenlty working on incremental refresh feature.

It's easy to use, it's fast and automated. Feel free to DM me in you want to Trial it or need any assistance.

Cheers!

Anton

===

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-easonf-msft]

Hi, @Anonymous 

I'm sorry. As of now , you can  extract the data from ServiceNow to power bi using rest API,but this will not support incremental refresh as ServiceNow rest API does not support query folding.

You can check if the solution in this blog helps.

https://curatedsql.com/2020/05/21/power-bi-incremental-refresh-against-web-api/

In fact, I would rather suggest that you add it as an idea to the Power BI Ideas forum for your needs or

 go to the Servicenow forum for help.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Anonymous , refer if this can help

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh

[Anonymous]

Hi @amitchandak  I have gone through the link, but my REST API does not support query folding. How to achieve incremental refresh ?