Category

Excel

Power BI Data Lineage Experience For Dataflows

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…

Read More

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…

Read More