Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
551 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
How to view the SQL query for a series of transforms in Query Editor |
---|
Did you know that you can view the SQL for a query in Power BI's Query Editor? Me neither! |
So here's a thing I didn't know (thanks, Sam). If you've imported some data into Power BI using Query Editor, you can see the associated SQL query:
Providing that you haven't done anything too outlandish, you can see the native query for the series of transforms that you've applied.
This only works if you're loading data from a source which has a native query language, of which SQL Server is one obvious example (if you try to doing the same thing after loading data from Excel the option above is greyed out).
Here's what I got for the above example:
The query for the series of steps above.
When you add a new column, Query Editor sometimes manages to translate it into SQL and sometimes doesn't. Here's an example of one which did work:
I used Column by Example to show the length of each film name, and Query Editor successfully turned this into SQL.
And here's an example of a transform which didn't work:
Alas, the Split by Delimiter task was a step too far, and couldn't be translated into SQL.
Whether this will actually help anyone, I'm not sure!
Some other pages relevant to the above blog include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.