In modern BI projects, understanding the flow of data from the data source to its destination, and understanding the data transformation done along the way, is a key challenge for many customers. This challenge becomes even bigger if you have built advanced analytical projects spanning multiple data sources, artifacts, and dependencies. Questions like “What happens…
Category
Excel
Combining Excel Files Hosted On SharePoint Folder With Power BI
This post was contributed by Ken Puls and Miguel Escobar, Power BI experts and authors of the new ebook, “[M]agic Tricks for Data Wizards”. Have you ever wanted to consolidate, combine or append data from multiple excel spreadsheets or workbooks? I bet you have, and it has been a painful process either done manually or via…
Excel Announces New Data Visualization Capabilities With Power BI Custom Visuals
Custom visuals have become a key part of Power BI allowing users to tap into hundreds of different visualizations. It is hard to believe that a little over two years ago we announced the availability of the first batch of custom visuals in Power BI Desktop and the Power BI Service. But custom visuals go far beyond…
Finding Power Query Query Execution Times In Power BI And Excel Using SQL Server Profiler
Working out how long a Power Query M query takes to run – the first step to troubleshooting refresh performance problems in Power BI or Excel – is something I have blogged about several times (see here, here and here for example). However, there are problems with all of these methods such as the need to alter the M code…