Forum Discussion

TIMTIM's avatar
TIMTIM
New Member
3 years ago

Created columns with DAX on columns imported with Direct Query not working

Hello Folks 

I'm working on a project to ameliorate my skills using power BI

i created 3 tables on Oracle DB (data_2018, market segment and meals) i imported the data on power BI with direct query using this statement : 

select A.*,b.cost,c.discount,(STAYS_IN_WEEKEND_NIGHTS + STAYS_IN_WEEK_NIGHTS) as nbr from DATA_2018 A left join meal B on A.meal = B.meal left join client_segment C on A.market_segment = C.market_segment 

 

Then i created this column in DAX :  

Coln = Query1[NBR] * Query1[ADR] 
and this one : 
total = (Query1[CHILDREN] + Query1[ADULTS])* Query1[COST] + Query1[Coln] 
 
however, when i try to display the total on a card or use any other visual 
i get this message : 
 
Error Message:
ORA-00904: "c36": invalid identifier. The exception was raised by the IDbCommand interface. 
 
My Question is : how to solve this issue and if there and particular tips with DAX when we work using Direct Query
 
Thanks in advance

 

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago
     i imported the data on power BI with direct query

    No.  It's either Import Mode or Direct Query. But not both.

     

    The error happens on the Oracle side. Check your views/queries there.