Forum Discussion
M language script that runs a text search in stored procedures in SQL server sys.databases
I have tried to design a M language script that runs a text search in stored procedures in SQL server sys.databases. When I view the script code in Advanced edit mode there is a note below the script that conclude with "No script errors are registrated".
Unfortunately I cannot identify what needs to be corrected in the script when reading the error message "Incorrect syntax near ''. " returned in PowerQuery .
It seems to me that the debug information in Power Query regarding execution of first step unfortunate is not present in current version of PowerBI Desktop.
Anonymous , would this not be a case to create a view upstream, and connect to the view?
5 Replies
- ImkeF
Community Champion
Hi Anonymous ,
what I see in the first picture you've posted looks like a correct result to me: It will appear when your parameter/query "paramDBname" is empty.
This is not an error on PQ side. - foodd
Anonymous , would this not be a case to create a view upstream, and connect to the view?
- ImkeF
Hi Anonymous ,
I don't have experience with DirectQuery mode, so cannot help you with it.
