The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
So we have a migration use case from GDS to Power BI. In GDS the same report will have data of different granularities. So for examples 3 connectors access 3 different data tables. One refreshes on monthly basis, another refreshes on weekly basis and the last one refreshes on daily basis.
This results in the visuals showing daily data to update daily, visuals with weekly data to update weekly, etc.
In GDS in the data connector itself has a refresh configuration but as far as I am aware in Power BI the entire report refreshes. Is this possible to configure something similar in Power BI or any workarounds anyone has worked with?
EDIT: Is there a solution for this in DataMart?
Read about Enhanced API Dataset refresh. Like with an OLAP cube you can selectively refresh individual tables and their partitions in a multitude of ways.
Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn