Forum Discussion

JohnnyDax's avatar
JohnnyDax
Icon for Helper I rankHelper I
3 years ago

Noobie question about SQL Query

My coworker left me a dataset which is connected to an azure pool and i need to add another column in it.   He used a specific SQL request to load his data and i expected to just edit that request ...
Need Help
JohnnyDax's avatar
JohnnyDax
Icon for Helper I rankHelper I
3 years ago

Hi,

 

Thank you for your answer,

 

mussaenda double click on source does nothing in my case

sevenhills i don't have the gear icone near source as usual, i suspect he just copy/pasted his request from another PBix, the "show native request" option is also greyed and can't be choosen

 

I guess i have to rewrite the request properly or edit it in M but that doesn't look easy compared to an SQL request.

sevenhills's avatar
sevenhills
Icon for Super User rankSuper User
3 years ago

Note: Always the first few steps are the ones where we connect. Then apply the query. if we know the steps, it will be easy to change or edit. 

 

Like I said in previous post, you can see all code in the advanced editor. and change.

 

Remove all sensitive info and

Please Share the code, I can take a look

Or share the screenshots

Or share the .pbix file.