Book Image

Microsoft 365 and SharePoint Online Cookbook

By : Gaurav Mahajan, Sudeep Ghatak
Book Image

Microsoft 365 and SharePoint Online Cookbook

By: Gaurav Mahajan, Sudeep Ghatak

Overview of this book

Microsoft Office 365 provides tools for managing organizational tasks like content management, communication, report creation, and business automation processes. With this book, you'll get to grips with popular apps from Microsoft, enabling workspace collaboration and productivity using Microsoft SharePoint Online, Teams, and the Power Platform. In addition to guiding you through the implementation of Microsoft 365 apps, this practical guide helps you to learn from a Microsoft consultant's extensive experience of working with the Microsoft business suite. This cookbook covers recipes for implementing SharePoint Online for various content management tasks. You'll learn how to create sites for your organization and enhance collaboration across the business and then see how you can boost productivity with apps such as Microsoft Teams, Power Platform, Planner, Delve, and M365 Groups. You'll find out how to use the Power Platform to make the most of Power Apps, Power Automate, Power BI, and Power Virtual Agents. Finally, the book focuses on the SharePoint framework, which helps you to build custom Teams and SharePoint solutions. By the end of the book, you will be ready to use Microsoft 365 and SharePoint Online to enhance business productivity using a broad set of tools.
Table of Contents (22 chapters)

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:

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

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

  1. Open the Power BI Desktop tool.
  2. Click on Get Data and select the Text/CSV option:

  1. Press Connect.
  2. ...