BY TOPIC▼
POWER PLATFORM BLOGS▼
POWER BI BLOGS▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Blogs from Wise Owl on Query editor in Power BI
Showing blogs 1-6 (out of 6)
Extracting external links from websites using Power BI
Posted by Andy Brown on 20 April 2022
Did you know that you could use Power BI as a tool to scrape websites, using the Html.Table M function? We didn't either until now!
The Magic of the Power Query SHARED Global Environment
Posted by Andy Brown on 26 July 2021
How to use the #shared keyword to bring up a list of all of the M functions in Power BI Query, and then use this list to create your own help table or even your own function.
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.