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

TIMTIM — Tue, 21 Mar 2023 14:42:30 GMT

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

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

lbendlin — Thu, 23 Mar 2023 01:11:18 GMT

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.

topic Created columns with DAX on columns imported with Direct Query not working in DAX Commands and Tips

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

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