The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
¿Es posible configurar la actualización incremental en Power BI Report Server?
Estoy buscando una forma de cargar solo datos nuevos o actualizados en un modelo para optimizar el rendimiento y evitar volver a cargar todo el conjunto de datos. ¿Existe alguna funcionalidad nativa o un enfoque recomendado para lograr esto en Power BI Report Server?
Thanks for Expiscornovus's concern about this issue.
Hi, @AnalistaLH
As stated by Expiscornovus , Power BI Report Server does not support the incremental refresh feature like Power BI Service.
Solved: Incremental Referesh in Report Server - Microsoft Fabric Community
This can be done by using SSAS as the data source, which supports incremental refresh. This requires setting up partitions in SSAS and configuring Power BI reports to use those partitions.
Partitions in Analysis Services tabular models | Microsoft Learn
Create and Manage Tabular Model Partitions | Microsoft Learn
If your data source supports it, you can use DirectQuery mode to ensure that the report always reflects the latest data without having to completely refresh it.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AnalistaLH,
As far as I understand (my Spanish is not great) you are looking for incremental refresh option in Power BI Report Server (like the one in the Power BI service, https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure)
As far as I know that feature is not available in Power BI Report Server, but you might find some pointers in the below thread:
User | Count |
---|---|
4 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
4 | |
4 | |
4 | |
3 | |
2 |