O'Reilly logo

Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, First Edition by Gil Raviv

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required