Awesome Way To Log in Power Query M Using Diagnostics.Trace

Several authors have described how to use the M function Diagnostics.Trace to monitor the performance of queries built with Power Query. In this installment, we will look at how to use the same function to record row-level error information in the trace log. Regardless of how we intend to use Diagnostics.Trace, nothing at all can […]
Read More ›

How to Import Data from R Scripts into Power BI

Power BI can obtain datasets from R scripts, though as of the September 2016 release of Power BI the integration is not so slick. For example, we may wish to explore a possible log-linear relationship in our data or the potential of a polynomial relationship. While we could, in principle, add columns to a dataset […]
Read More ›

Error Handling in Power Query

Hopefully, this blog will quickly become outmoded and useless and I will have wasted my time. Error handling in the Power Query Formula Language, most often simply called “M”, is weak compared with most modern programming environments, and the developers at Microsoft will no doubt address these issues and provide a better system. But, for […]
Read More ›

Creating Functions in M, The Power Query Formula Language

You have to be careful with economic data (with economists, too, but that’s an entirely different story). Is the data seasonally adjusted? Do the numbers represent current values or have they been adjusted to reflect the dollar’s average value in 2010? For such reasons, it is not uncommon for economists to annotate tables of data. […]
Read More ›

Using Excel Power Query to Append a File to a Table

Lots of people import text-based files into Excel tables. Sonia V. recently asked if it was possible to append data imported from a text file to an existing table. I am not aware of any technique to do exactly what Sonia wants, but we can do the next best thing. We can read an Excel […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.