BY TOPIC▼
POWER BI BLOGS▼
POWER BI BLOGS▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Blogs from Wise Owl on Query editor in Power BI
Showing blogs 1-4 (out of 4)
How to view the SQL query for a series of transforms in Query Editor
Posted by Andy Brown on 02 July 2019
Did you know that you can view the SQL for a query in Power BI's Query Editor? Me neither!
How to use an unpivot transform in Power BI Desktop (or PowerPivot) Query Editor
Posted by Andy Brown on 04 January 2018
If you get data in pivot (two-dimensional) form, you can unpivot it to get the underlying rows, and hence produce charts and visuals. This blog shows how!
How to write an M formula to convert Julian dates using Power Query
Posted by Andy Brown on 08 December 2017
This short blog explains how to convert Julian dates to "normal" ones, and how the formula used actually works!
How to reuse a query created in Query Editor or Power Query
Posted by Andy Brown on 29 November 2017
This short blog explains how you can copy and paste the steps of a query that you've created in Power Query (within Power BI Desktop). The steps also work for queries created in Power Query within Excel.