Power BI: Creating and Sharing Power BI Templates
jul 16,
2019
Templates are great for word processors and spreadsheets; they save time and enforce consistency. Templates are great for Power BI, too, but Power BI templates must solve a minor complication not faced by its sister Office applications. The measures, columns, and visualizations that collectively constitute a Power BI report are based on a specific data […]
Preparing SQL Data for R Visualizations Using Power Query Pivot
jan 11,
2019
The Data Frame The fundamental data structure used by the majority of R functions and packages is the data frame. In a data frame, sets of related values constitute rows, while an individual column vector in a data frame contains comparable measures that can be summed, averaged, or subjected to any number of numerical manipulations. […]
Interactive Visio Diagrams in Power BI Reports
aug 8,
2018
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 […]
Live SQL Server Data in Power BI: Using DirectQuery
maj 15,
2018
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 […]
Introduction to M, the Power Query Formula Language
jan 18,
2018
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, […]