Forum Discussion
Post ProdigyAppend Data
Hey stribor45 ,
you can't because this is how it works. You can consider using incremental refresh, even if API-based data sources are not supporting incremental by default. Start reading everything GilbertQ wrote about incremental refresh: https://www.fourmoo.com/2020/07/01/how-to-configure-incremental-refresh-with-power-query-in-power-bi/
Hopefully, this provides enough to get you started.
Regards,
Tom
Post Prodigyok after I followed the steps I published it to service but when I refresh there I get this error. i followed the link provided in error and apparently since this is a dynamic data source it can't be refreshed in the power bi service. "Some data sources may not be listed because of hand-authored queries. If that warning is present in the Data Source Settings dialog that appears, then a dynamic data source that can't be refreshed in the Power BI service is present."
The tutorial above also has API call as well but somehow it managed to refresh. Any suggestions?