Forum Discussion
unable to use power query while data comes from direct query in one lake.
in the Power BI web app, i have data in the One Lake data hub which comes thorugh direct query from ERP/Oracle How can I transform data? in Power BI desktop data is in Power BI datasets. Moreover can I use Dax formulas?
Thanks in Advance
1 Reply
- AnkitKukreja
Super User
Hi makhan4599
You cannot use Power Query if your model is in DQ mode. This is by design. You need to have measures at source level. Yes, you can use the dax functions but all the dax functions would also not be available for use. You can refer to this doc for more insights on this.
