Forum Discussion
Solved
Redshift and data folding error
I am using a redshift database, and I can connect to that OK in Power BI Desktop. My problem comes when I try to use some calculated fields; I have simplified some down to try and find the error so ...
DrBiker I'm assuming you are connecting to RedShift in DirectQuery mode. This error is thrown when some aggregation (in this case the count) is been translated to M for execution, so it's not really SQL yet.
I think this is related to a bug that we know about, is [flag] a nullable column? Counting on nullable column wasn't working in the preview bits, we will be fixing it in the next release.
Redshift is in preview mode, so I guess it is a bug. Send a frown using the desktop frown so the developers can look at it.