Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 ...
Need Help
v-xicai's avatar
v-xicai
Community Support
6 years ago

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.