Does direct connect support query parameter as a list?

[AnandNamburi]

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.

[Anonymous]

Hi @AnandNamburi ,

It is by design, you may consider to submit this as an idea.

https://ideas.powerbi.com/ 

Switch the connect mode to Import will solve this issue.

Best Regards,

Jay

[amitchandak]

@AnandNamburi , In direct query mode, transformations are limited to simple column creation etc. You can not do complex transformation

refer

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#modeling-limitation...

Power BI Decoding Direct Query: https://www.youtube.com/playlist?list=PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA