Forum Discussion
Appending Queries & Refresh
Hello, I am developing a Power BI report based on CRM data. Our team has been told to use a new CRM system - however some of the data in this new CRM system is still not accurate, so I am queryin...
I do not believe so, but would like to be shown wrong. The reason is the Table.Combine() function often doesn't fold, which is required for incremental refresh. Your best bet will be to stage this data in a server (SQL Server for example) then create a view that has all 3 in one table, then set up IR on that view.
You could load the historical info in another table and set it to not refresh, but that splits your fact table and makes the DAX both messy and slower as you start working.