Interactive Visio Diagrams in Power BI Reports

When I first evaluated Power BI a few years ago, the thing that impressed me most was that, unlike Sharepoint Power View, a developer could create new visualizations and integrate them into PBI. Some time later, Microsoft greatly expanded the ability of Power BI to include sophisticated graphs by adding to Power BI the ability […]
Read More ›

Live SQL Server Data in Power BI: Using DirectQuery

For me, one of the most valuable features of Power BI is the ease with which I can mashup data from a variety of different data sources. This, of course, requires importing data into Power BI’s internal xVelocity engine. For many others, however, it is critical to create Power BI reports and dashboards that reflect […]
Read More ›

Introduction to M, the Power Query Formula Language

Its name is Power Query Formula Language. But if you call it that, no one will know what you are talking about. The original informal language name M seems to have stuck, and even the Microsoft documentation refers to M. Every time you create a query in Power Query, whether in Excel or Power BI, […]
Read More ›

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 ›

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 ›

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.