Cannot add a parameter in direct query mode ??

[Anonymous]

My power bi desktop version is  2.79.5768.721 64-bit (March 2020)

I am tyring to add a parameter while Transform data step, which I did, and then I say close and apply, then I get this error,

I am using directquery mode, why is this happening ? Also, why do i not see Edit Queries in this version of powerbi desktop ?

[v-xicai]

Hi  @Anonymous  ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

Hi @Anonymous ,

Based on my test connecting to SQL Server with DirectQuery mode in the latest version 2.83.5894.721 of Power BI Desktop, creating a parameter is ok in Query Editor. You may upgrade the Power BI Desktop to the latest version , and try it again.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous what is your data source? If it is a live connection or direct query to SSAS MD, you cannot make any changes to the model.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

Data source is Oracle