Forum Discussion
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-ticketIf 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.
Hello,
Please share more details regarding the setup. Can you please show screenshot from Power Query where you do the setup?
Please note feedback from v-ssriganesh.
The data source must be able to support incremental refresh. Usually this is a relational database (SQL, Oracle etc).
Other data sources such as API, Excel would not support incremental refresh as you source must be always online and running.
The way to tell in Power Query is shown in the screenshot below:
Right click the steps (each one if you have many) and look for "View Native Query". As you can see for me this is greyed out. This means that step is unable to be sent back to the data source (folded).
If "View Native Query" is avaiable then you can click to the see the underlying SQL code which gets sent back.
Summary - if the above option is greyed out, verify your source is an active relational database.
If not greyed out then your incremental refresh should work. Just go through all the steps because even with relational database, some transformations and steps cant be sent back to the source. HTH.