CHAPTER 8Addressing Collaboration Challenges

Great things in business are never done by one person. They’re done by a team of people.

—Steve Jobs

IN THIS CHAPTER, YOU WILL

  • Learn how to use parameters in Power Query for paths of local data sources

  • Use Power BI templates in conjunction with parameters to enable multiple co-authors to import data from local files

  • Learn the limitations of parameters in Excel and how to use tables or named ranges as parameters

  • Learn how to resolve firewall errors and consolidate queries

  • Learn how to connect to shared files on OneDrive for Business and SharePoint

  • Learn how to connect to specific subfolders on SharePoint and how to modify queries that connect to local folders so they can import data from SharePoint ...

Get Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, First Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial