Let Power Query write your SQL for you!

We tell you to push your transformations upstream as much as possible. But you don't know how to write SQL. That's ok, let Power Query do it for you to move your project forward. Patrick shows you how!


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #GuyInACube

[deejohn]

My company is using Paginated reports through Power BI Report Builder. I have been creating "proto-types" in Power BI to show end users before I build the whole thing as a Paginated report - this 6-minute video will have me days --- if not weeks of work - Thanks Patrick!!!!😁

[GregKramerTenaciousData]

lookout DBAs!....Patrick is giving away secrets

[davidwilliamsjr]

This is super cool. I write queries directly from the server, but this will definitely help with future projects! Thank you!

[TumiSelepe]

Patrick!!! I spend my whole afternoon creating views I didnt know I can create them this fast!!!!game changer this one

[foxusmusicus]

wow amazing. Never thought about. Thank you for sharing and kudos to the guy who mentioned it

[kais.rekouche]

That's really handy, to be able to translate all the logic into SQL, that's amazing, thank you for this post Patrick

[khawarmalik]

Wow this is really cool stuff. Thanks for sharing.

[mockapp]

Amazing how this has been under the hood of Excel for decades in other forms. However, its nice to see another generation learn from this.

[torsteinzahledvardsen]

This such a cool feature! And think about the posibilities to use Power BI for development and thereafter push it more upstream in the BI-model for the company!

[frasermartens]

Is there a reverse version of this, that could take a SQL query and turn it into M? Because that would be extremely helpful for getting folks on my team's heads wrapped around working in M.

[abbielmi]

Hi it's cool, i just can't see the last column when my table should be listed it's relationship

[amarkhaliq]

Hi Patrick I am currently using sql views but if I need to create a lot of sql views say 5/6 per report that can bloat up my view folder really quickly can you provide any organisation/management advice would really appreciate it. Using Oracle sql developer

[visheshjjain]

If the query is already folding, is there still a requirement to create a separate view?

[KhalidKhans]

Excellent Patrik, Well Done, You are a genious Teacher
Khalid Khan, Islamabad, Pakistan

[sabastian]

Now I will use this after all my Transformations in PQ and create views for the entire data model. I will now only have 1 query in PQ steps, which will be "Source"

[clifordakoyo]

can you send me the link to the data I follow through?

[lalalf]

Hi Patrick. Please, help me. PBI don't load data. I see the message (Load. Evaluation)

[mattmatt]

Power query replaces sql. You can create all your queries quicker with gui rather then writing a code.

[CaribouDataScience]

Does this mean that Power BI Is just a "wrapper" for SQL Server :)

[samaguire]

I've been doing this for years with PQ in Excel. And after a while realized it wasn't worth the effort to convince DBAs to create views when there is no performance benefit for me. Different if you get a good DBA who will create a materialized view and perf tune, but in general those DBAs are a rare breed.