Forum Discussion
AnandNamburi
Helper III
Helper IIIDoes direct connect support query parameter as a list?
Hi All,
I'm using direct query mode to build a report. To create a parameter I'm using query option in that. To enable the query as a list I another query with transformation and when I apply save it throwing error as "Query contains transformation can not be used in Direct Query".
How we can eliminate this error.
2 Replies
- amitchandak
Super User
AnandNamburi , In direct query mode, transformations are limited to simple column creation etc. You can not do complex transformation
refer
Power BI Decoding Direct Query: https://www.youtube.com/playlist?list=PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA
Hi AnandNamburi ,
It is by design, you may consider to submit this as an idea.
Switch the connect mode to Import will solve this issue.
Best Regards,
Jay
