I am doing a Direct Query, but get error in chart when analyzing data

[#1]

When I try to put my data in a table, this error comes up. I don't understand since I created the same report without Direct Query and works fine. I am trying to use the Direct Queries to see how they work

The query goes like:

     DIRECT QUERY
          dimension

               memberId,

               date,

               other fields

         from tableA, tableB, tableC, factTable

         where tableA.id = factTable.id

          and tableB.clientId = factTable.clientId

          and tableC.otherId = factTable.otherId

Thank you,

Andres