Forum Discussion
Dataflow Incremental Refresh Update Specific Partitions
Anonymous
The incrementally refreshed partitions should not be visible in the service and need to use external tools like ssms. Your data source may not support.
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ Janey
thank for your help v-janeyg-msft - I think will need to close this and leave it as unsolved. Perhaps the documentation on the following page needs to updating:
Using incremental refresh with dataflows - Power Query | Microsoft Docs
I believe the sentence "After XMLA-endpoints for Power BI Premium are available, the partition become visible." This is true for Datasets (i.e. because they are Analysis Services Tabular Databases, but it is not true for Dataflow.
Dataflows would be JSON and CSV files in the Power BI's Azure Data Store. These can't be accessed using the XMLA Endpoints because it is not analysis service object.
Perhaps the documentation needs to be updated by: bensack , @DCtheGeek and @steindav
to say that this is not possible or to explain how it is possible.
Hi, Anonymous
I only have the data source of the SQL database. After I set the incremental refresh of the dataflow, check the refresh history and download the results, and I can see the partition name in excel. As for what can be done to the partition, I didn't find any settings on the service.
Best Regards,
Community Support Team _ JaneyHi, Anonymous Anonymous
Update: XMLA Endpoint can be only used to connect to Power BI Premium Dataset for now, and Dataflow cannot use this way to refresh some specific partition. The customer needs to either do full refresh or re-configure the Incremental refresh policy to include the year data to be refreshed.
Best Regards,
Community Support Team _ Janey