Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hola, buenas tardes, si tengo un proyecto en power BI que lee datos desde un API, informacion de un año y es demasiada información, el dueño del API dice que solo puede entregar datos de a dos meses, como podria configurar una carga incremental del ultimo mes, si no puedo hacer una carga masiva de 11 meses?
que opciones exisen en power BI para resolver este reto?
Solved! Go to Solution.
HI @Josehp,
Did you mean the paginated API? If that is the case, I'd like to suggest you refer to the official document sample code to repro this operation in your query table:
Helper functions for M extensions for Power Query connectors - Power Query | Microsoft Docs
In addition, incremental refresh requires the data source support query folding. If your data source supports this, you can modify the refresh ranges as the document mentions:
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
HI @Josehp,
Did you mean the paginated API? If that is the case, I'd like to suggest you refer to the official document sample code to repro this operation in your query table:
Helper functions for M extensions for Power Query connectors - Power Query | Microsoft Docs
In addition, incremental refresh requires the data source support query folding. If your data source supports this, you can modify the refresh ranges as the document mentions:
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
@Josehp , Refer if these can help
https://sqldusty.com/2020/05/20/power-bi-incremental-refresh-with-web-api-data-source/
https://datachant.com/2016/06/27/cursor-based-pagination-power-query/
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |