Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Incremental Refresh with Dataverse

Hi!! Im wrtiting today in order to know if Incremental refresh works with Dataverse? The issue is because ive been trying to apply incremental refresh to some .xlsx files inside a  sgarepoint f...
@microsoft
dataverse
Incremental Refresh
lbendlin's avatar
lbendlin
Super User
2 years ago
 ive been trying to apply incremental refresh to some .xlsx files inside a  sgarepoint folder

Incremental Refresh in the context of Power BI requires the presence of SSAS Tabular partitions.  You can create a semantic model with a incremental refresh data source based on Excel files (using the file create date for the mapping) but you cannot incrementally refresh an Excel file, regardless of Dataverse or not.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi!

In this case what would you recommend, try to see if Incremental refresh is available for dataverse and try to upload the data there, or

Upload the files into a SQL Server database?

Thanks & Regards,

Alejandro


  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Incremental Refresh in the context of Power BI semantic models requires the presence of (SSAS Tabular) partitions.  A SQL server database won't help with that.

     

    If you insist on using Dataverse then you can consider using Incremental Refresh for dataflows  which follows roughly the same rules but has a very different storage.