Forum Discussion

DrBiker's avatar
DrBiker
Advocate II
10 years ago
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 ...
Need Help
  • pqian's avatar
    pqian
    10 years ago

    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.

pqian's avatar
pqian
Microsoft Employee
10 years ago

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.

  • arify's avatar
    arify
    Microsoft Employee
    10 years ago

    pqian is right, this should be fixed in the next release (~end of august). Thanks

    • sabedin's avatar
      sabedin
      Helper I
      8 years ago

      Hi,

       

      I am getting the same error message (although different DAX formula!!!

       

      Is this fixed or not?

       

      Thank you!