Forum Discussion
Append 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
TomMartens I couldn't follow that tutorial so I found some other resources online and was able to set it up in Power Bi Desktop.
- I have one table of data that contains column with the datetime
- I created RangeStart and RangeEnd parametars
- Filtered data based on #2
- Refreshed in Power BI Desktop and everything works fine
- Published to Power BI Service and receiving error
Error received is "This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources"
After some reading on that link and following Chriss Webb Article
I adjusted my API call to include relativepath and query parametars in Web.Contents() call but error still remains. Is there a way to see mor einformation about actual error in power bi service?
Thank you