Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dataflow Incremental Refresh Update Specific Partitions

I understand how a specific partition can be refreshed in Power BI Dataset using SSMS or Tabular Editor via the XLMA Endpoints.  Thanks GuyInACube  My question is how can I refresh specific partit...
Dataflow
Anonymous's avatar
Anonymous
Not applicable
4 years ago

v-janeyg-msft 
It is another Dataflow in the same workspace.  The JSON file is loading into a Standard Dataflow.  The Incremental Dataflow is reading from this initial Dataflow.  Are both the Standard and Incremental Dataflows not considered "Azure Data Lake Storage".  Would the Workspace need to be configured to use Gen 2 storage? 

 

Or do both the dataflow need to be switched to "Enhanced Compute Engine" (I thought be default this would be on because the Dataflows are linked?):

 



    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.

      • v-janeyg-msft's avatar
        v-janeyg-msft
        Community Support
        4 years ago

        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 _ Janey