Power BI incremental refresh from Shopcada store using API

Hello Perfecta,
We regret the inconvenience caused. Please consider raising a Microsoft support ticket for further investigation. You can explain all the troubleshooting steps you have taken to help them better understand the issue.

You can create a Microsoft support ticket with the help of the link below:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

If this helps, please "Accept as solution" and drop a "Kudos" so other members can find it more easily.

Thank you.

Hi Perfecta 

Based on available info, it sounds like the source doesnt fully support incremental refresh because its using an API.

The suggestions from Microsoft are to use a staging layer. Basically its means if you can move you API call to a SQL DB or something similar then that could work.

Another thing I would suggest is, can you move you Power Query M code to a Power BI Dataflow?

Dataflows sit in the cloud and they have slightly different behaviour to local queries. You can try moving the query to a Data flow and then connect to the data flow through desktop.  The Data flow also supports incremental refresh.  It should be easy to setup and you simply need to copy paste your query to a dataflow.  Worth testing.