Custom SQL Query no longer accessible...

A7T57ZZ · ‎10-11-2022

So this is strange. I am bringing in data via SQL from a HANA view and my option to edit the query is no longer there. Any ideas on why this happened.

ImkeF · ‎10-11-2022

I've seen things like this happening after I have entered some optional parameters or additional functions instead of simple standard parameters.
You can still edit the function parameters through the formula bar or the advanced editor.
But if you prefer the UI-based configuration, you have to start the query from scratch, I am afraid.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries