Forum Discussion
Cannot add a parameter in direct query mode ??
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 ?
4 Replies
- parry2k
Super User
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.⚡
v-xicaiCommunity Support
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.
- 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
