Forum Discussion
Incremental refresh with Append Queries from different Sources
I have 2 sources for my Fact table: - One is SQL Server (accounting system) - Excel in Sharepoint (where we enter consolidation journal entries that are not inside the accounting system) I combine...
But they are not two separate tables in the dataset.
I append them in a new query and only the AppendedFactTable is loaded to the dataset
The 2 original queries are not loaded into the model, so there is no option for me to set an incremental refresh...
Hi
Did you find the solution to your problem? I have similar