cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LucienF38 Regular Visitor
Regular Visitor

Transform SQL code into power BI // Need Help

Dear all,

 

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

 

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 Smiley Happy 

 
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Transform SQL code into power BI // Need Help

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

 

image.png

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





3 REPLIES 3
Super User
Super User

Re: Transform SQL code into power BI // Need Help

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

 

image.png

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





LucienF38 Regular Visitor
Regular Visitor

Re: Transform SQL code into power BI // Need Help

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,


Super User
Super User

Re: Transform SQL code into power BI // Need Help

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






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 31 members 825 guests
Please welcome our newest community members: