Data Connectivity

Power BI Section

Power BI Section

Overview

Power BI supports a wide range of data sources, making it a versatile tool for data analysis. You can connect to various types of data, from simple Excel spreadsheets to complex SQL databases, and even cloud services and streaming data.

Supported Data Sources

  • Excel spreadsheets
  • CSV files
  • SQL databases (e.g., SQL Server, MySQL, PostgreSQL)
  • Oracle databases
  • Azure SQL Database
  • Google Analytics
  • Salesforce
  • SharePoint
  • OData feeds
  • Web sources (e.g., JSON, XML)
  • Streaming data (e.g., Azure Stream Analytics)
  • Facebook
  • Adobe Analytics
  • Amazon Redshift
  • MongoDB
  • IBM Db2
  • Snowflake
  • Google BigQuery
  • Apache Spark
  • Twilio
  • MailChimp
  • GitHub
  • Zendesk

Examples and Steps

Connecting to an Excel Spreadsheet

To connect to an Excel spreadsheet in Power BI:

  1. Open Power BI Desktop.
  2. Click on 'Get Data' from the Home ribbon.
  3. Select 'Excel' from the list of data sources.
  4. Browse to the location of your Excel file and select it.
  5. Click 'Load' to import the data into Power BI.

Connecting to a SQL Database

To connect to a SQL database in Power BI:

  1. Open Power BI Desktop.
  2. Click on 'Get Data' from the Home ribbon.
  3. Select 'SQL Server' from the list of data sources.
  4. Enter the server name and database name.
  5. Provide your credentials and click 'Connect'.
  6. Select the tables you want to import and click 'Load'.

Comments

Post a Comment