Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Microsoft 365 and SharePoint Online Cookbook

You're reading from Microsoft 365 and SharePoint Online Cookbook A complete guide to Microsoft Office 365 apps including SharePoint, Power Platform, Copilot and more

Product type Paperback

Published in Feb 2024

Publisher Packt

ISBN-13 9781803243177

Length 640 pages

Edition 2nd Edition

Tools

Office 365

Concepts

Information Management

Authors (4):

Scott Brewster

Gaurav Mahajan

Sudeep Ghatak

Nate Chamberlain

View More author details

Table of Contents (15) Chapters

Preface

1. Overview of Microsoft 365 FREE CHAPTER

2. Introduction to SharePoint Online

3. Modern Sites in SharePoint Online

4. Lists and Libraries in SharePoint Online

5. Document Management in SharePoint Online

6. OneDrive

7. Microsoft Teams

8. Power Automate (Microsoft Flow)

9. Creating Power Apps

10. Applying Power Apps

11. Power BI

12. Overview of Copilot in Microsoft 365 and Power Platform

13. Other Books You May Enjoy

14. Index

Retrieving data

Retrieving is the process of fetching data from a location. Power BI has connectors to various data sources, ranging from text and comma-separated values (CSV) files to databases, as well as web pages. Some common Power BI connectors are shown in the following screenshot:

Figure 1: Power BI Connectors

In this section, I will demonstrate how you can retrieve data from a CSV file.

Getting ready

Download the Products_bikes.csv file fromChapter 15 folder in the GitHub repository of this book here https://m365book.page.link/github

You don't need any special permission to retrieve data from files such as text, CSV, or Excel files.

If you are querying a secure data store, you might require additional permissions.

How to do it...

Open the Power BI Desktop tool.
Click on Get Data and select the Text/CSV option:
Press Connect.
Browse to the location of the CSV file and open the Products_bikes.csv file.
Click Load.
Power BI Desktop...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (4)

Mahajan

Mahajan

Gaurav Mahajan is a Microsoft Technology Solutions Professional who specializes in Microsoft 365, SharePoint, and AI, with over 19 years of technical consulting experience. Gaurav has a bachelor's in engineering, is Stanford certified in machine learning, and holds a PG Diploma in management from the Indian Institute of Management. He speaks at and organizes technical events, code camps, and conferences. He is a co-chair of the M365 & SharePoint Saturday, Pittsburgh (US) annual conference.

See other products by Mahajan

Sudeep Ghatak

Sudeep Ghatak

Sudeep Ghatak is a Microsoft MVP in Business Applications and a frequent contributor to the Power Automate Community forum. He works as a Principal Architect in Christchurch, New Zealand and loves designing solutions based on Office 365 and the Azure platform. He is a certified Solutions Developer (MCSD) and holds a postgraduate degree in instrumentation engineering. He is an active member of the Microsoft community and often seen speaking at user groups and conferences in New Zealand.

See other products by Sudeep Ghatak

Nate Chamberlain

Nate Chamberlain

Nate Chamberlain, a Microsoft 365 Enterprise Administrator Expert and Microsoft MVP in Office apps and services since 2019, has over 5 years of experience in helping organizations deploy and maximize their usage of Office 365 apps and services. His work has included administrative and analyst roles in the higher education, healthcare, corporate, and finance sectors. Nate is the author of several other books, including an MS-101 exam guide, an MS-500 exam guide, and a handful of smaller publications on SharePoint, OneNote, and leading advocate groups. Nate speaks at user groups and conferences both in person and virtually throughout the year, and blog and tweets regularly as chambernate.

See other products by Nate Chamberlain

Scott Brewster

Scott Brewster

Scott Brewster is a Microsoft 365 Solutions Architect. He has supported numerous government clients focusing on SharePoint and Microsoft 365 since 2008. His focus is on security, administration, migration, governance, and training. Scott has been speaking at conferences and user groups since 2010 and runs the SharePoint User Group of DC.

See other products by Scott Brewster

Personalised recommendations for you

Based on your interests and search pattern

Mastering Customer Success

Mastering Customer Success

This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.

May 2024 5h 40m

Architecting Salesforce Success

Architecting Salesforce Success

This book provides you with a roadmap to becoming a successful Salesforce Architect. Covering common pitfalls and valuable insights, this book prepares you to transition to the role of a Salesforce Architect.

The SketchUp Handbook for Interior Design

The SketchUp Handbook for Interior Design

The SketchUp Handbook for Interior Design walks interior designers and architects through SketchUp Pro and Studio at an intermediate+ level, covering topics and tools specific to the world of design.

Jun 2024 19h 56m

Power Platform and the AI Revolution

Power Platform and the AI Revolution

Learn how to integrate cutting-edge AI technology into business operations and tap into AI services within Power Platform to enable automation and develop apps and chatbots to achieve heightened productivity and efficiency.

May 2024 11h 52m

Mastering Project Management with ClickUp for Work and Home Life Balance

Mastering Project Management with ClickUp for Work and Home Life Balance

This book will guide you in using ClickUp to become a power user of your life. You'll learn practical strategies for setup, project management, and AI integration to optimize workflow, boost productivity, and manage time effectively.

Jun 2024 10h 16m

Mastering UI Development with Unity

Mastering UI Development with Unity

With Unity's robust toolkit, you can create visually appealing UIs to give your games a professional look and feel. This book will help you realize the full potential of the UI systems provided by Unity, so you can create the best UI for your games.

Jun 2024 21h 16m

Autodesk Civil 3D 2025 Unleashed

Autodesk Civil 3D 2025 Unleashed

This book is a comprehensive guide to using Autodesk Civil 3D. You'll progress from design customization with extensions and information management to project extension, preparing you for a successful career in civil engineering.

Jul 2024 10h 28m

Mastering Salesforce Experience Cloud

Mastering Salesforce Experience Cloud

Mastering Salesforce Experience Cloud covers every facet of the platform, from technical reviews to implementation, business transformation, and long-term growth strategies. Learn to maximize the potential of Salesforce Experience Cloud.

Oct 2024 10h 56m

Mastering the Art of Sales Engineering

Mastering the Art of Sales Engineering

This book covers what a sales engineer is and does, and why this is a highly paid and coveted role. The authors share their vast experience to help you learn daily operations and skills to advance your sales career.

Sep 2024 10h 32m

Taking Tinkercad to the Next Level

Taking Tinkercad to the Next Level

Tinkercad users familiar with the basic functionality will learn to create complex shapes and multi-part designs with this book on advanced modeling. It covers strategies and techniques for modeling and designing for production with 3D printers.

Sep 2024 13h 56m