Forum Discussion
Solved
Using SQL Server with Nonclustered Columnstore Index
Hi everyone, I'm trying to load data from a SQL Server 2017 table with a Nonclustered Columstore Index. I'm primarly using a columnstore index due to the compression benefits. The underyling row...
Forgot to update with the solution:
I had messed up the creation of the NCCI index and not included 2 columns in it that PowerBI was querying.
The SQL server therefore had to, of course, use the rowstore. It worked fine after fixing the index.
Forgot to update with the solution:
I had messed up the creation of the NCCI index and not included 2 columns in it that PowerBI was querying.
The SQL server therefore had to, of course, use the rowstore. It worked fine after fixing the index.