Transform SQL code into power BI // Need Help

[LucienF38]

Dear all,

I've been stuck on a big issue for a long time and the community is my last hope !! 😞

I have a SQL code that I want to reproduce into power BI. I've been trying all my ideas in power query editor and can't get rid of it...

Do you know if Power BI can recognize a SQL code ? If yes how ? Maybe in direct query ??

If no, does anyone can help me to "translate" the highlighted lines below ? I can't compute the "match between orders and quotation" lines.

Somes indications :

- CO = Orders

- Q = Quotations

Thanks for helping 🙂 

[parry2k · Accepted solution]

@LucienF38 you can write sql query when connecting to sql server, see image below.

[LucienF38]

Hello @parry2k ,

Yes I tried but it is asking me a confirmation to act on the native database. I'm freaking out that it would have some negative impact on it and moreover because it's not mine but my company's. Do you know what are the risks, considering my code ?

So I would prefer to do it myself. So is anyone able to translate the part in red ? 

Thanks,

---

[parry2k]

@LucienF38 I don't think you need to worry about the warning message and use SQL Query in your model.