Data Sources and

connectors for Power BI

SARA KUTTY
SJU
Types of Data Sources for Power BI
Services

 Files
 Content Packs
 Databases
 Data Sources - Files

• Excel
• Power BI Desktop (.pbix)
• Comma Separated Value (.csv)
 Data Sources - Content Packs

 contain the majority of the data and

reports you require effectively
arranged for you.
 Administrations
 those from administrations like Google
Analytics, Marketo, or Salesforce,
 Authoritative
 those made and shared by different
clients in your association.
 Data Sources - Databases

 Databases in the Cloud

 you can interface live to Azure SQL Database,
Azure SQL Data Warehouse, Spark on Azure HD
Insight, and SQL Server Analysis Services utilizing
DirectQuery
 Databases On-Premises
 you can associate specifically to SQL Server
Analysis Services Tabular model databases. A
Power BI Enterprise passage is required.
 For different kinds of databases in your association,
you’ll have to first utilize Power BI Desktop or Excel to
interface with, inquiry, and load data into a data
show. You would then able to import your record
into Power BI where a dataset is made.
Microsoft Power BI Connectors

 The process of connecting Power BI to various data sources is made easier

with Power BI connectors.
 Power BI Data Connectors enable you to connect your data sources to
the Power BI system securely without expensive re-engineering, testing, or
retraining.

 Subsequently, through a secure connection you can:

 Visualize Power BI reports
 Perform robust analytics
 Utilize various Power BI services
 BI Connector is secure, easy, and has every feature you require in a Power
BI connector.
Different types of Power BI Connectors

 Files Connectors
 Excel
 PDF
 Power BI you can extract tables or entire pages of information from PDF files for inclusion in our spreadsheets or
data models.
 By creating persistent connections to PDF files, you can auto-update your spreadsheets/Power BI whenever
the PDF file receives new data.

 XML
 JSON
 you can export data from JSON files in form of a table to create different types of visualization.
 Power Query uses automatic table detection to seamlessly flatten the JSON data into a table. You can then
continue to transform & visualize the data.

 Text/CSV
Different types of Power BI Connectors

 Database Connectors
 SQL Server
 Power BI provides an optimized, live connector to SQL Server to easily create charts,
reports, and dashboards by directly working with a large amount of data.

 Azure SQL Database

 Power BI Connector allows you to explore and monitor data stored in your Azure SQL
database directly, without requiring a data model as an intermediate cache.
 With Azure and Power BI, you can utilize multi-source data processing, huge real-time
systems, Stream Analytics, etc.
 You can also connect Power BI to the Azure SQL database using a single sign-on (SSO)
such as Azure Active Directory (Azure AD) or OAuth2.
 Different types of Power BI Connectors

 Database Connectors
 Amazon Redshift
 You can connect Power BI to Amazon Redshift directly using the in-built connector.
 The AWS Redshift to Power BI connectivity allows users to analyze the entire set of data that is stored in the S3 data
lakes with Redshift.

 Google BigQuery
 Power BI can be connected to Google BigQuery in two ways:
 Using Organizational account

 Using Service Account Login that requires JSON key file contents.

 The Power BI connector is available in Power BI Desktop and in the Power BI service for Google BigQuery.
 In the Power BI service, the connector can be accessed using the Cloud-to-Cloud connection from Power BI to
Google BigQuery.
 Different types of Power BI Connectors

 Database Connectors
 Oracle Database
 Oracle users can track, aggregate, and visualize data from internal apps by connecting Power BI to Oracle
Database.
 You can directly load data from the Oracle database using the Power BI connector.
 As a prerequisite, it requires the installation of Oracle Client beforehand.
 You can also want to use an external Connector for Oracle such as CData for ease of use.

 Snowflake
 Snowflake provides the flexibility to store both structured and semistructured data.
 Power BI Connector eliminates the need for on-premises Power BI Gateway implementations since the Power BI
service uses an embedded Snowflake driver to connect to Snowflake.
 Power BI Service users can connect to Snowflake using Identity Provider credentials and implement to access
Snowflake with single sign-on (SSO).
Different types of Power BI Connectors

 Database Connectors
 IBM
 The IBM Db2 database is used by organizations of all sizes for both transactional and
analytical operations.
 Power BI Connector for IBM Db2 allows Data Scientists to perform complex modeling
and visualizations.
 You can create a real-time link to visualize live data, and refresh data on demand or
use the schedule refresh option to view the latest data in Power BI.
 Different types of Power BI Connectors

 SaaS Connectors

 Salesforce
 Salesforce is a cloud-based CRM tool that lets you manage your organization’s interactions with
its customer base.
 Power BI Connector gives users the ability to easily connect Salesforce accounts, to retrieve data
in Power BI.
 To execute the connection:
 Launch Power BI on your workstation
 Click on the Get Data button
 Select the “analytics for salesforce” option

 The connector will power your visuals for analyzing your marketing/sales performances.
 It provides key metrics, such as your sales pipeline, best accounts, and KPIs.
Different types of Power BI Connectors

 SaaS Connectors
 Google Analytics
 Google Analytics is a widely used Website Data Analytics tool that tracks data on SEO,
transactions, user behavior, Sales, Marketing, etc.
 Connecting Power BI to Google Analytics simplifies your website performance analysis.
 Using the Power BI Connector, you can easily establish a connection between the two
& analyze your data in real-time.
 Just like the Power BI desktop, the SaaS application also supports connectivity to
Google Analytics with simple configuration & authentication.
Different types of Power BI Connectors

 SaaS Connectors
 Zoho Creator
 Visualize Zoho CRM customers, transactions, invoices & sales data in Power BI with an in-built Connector.
 The Zoho Creator connector facilitates the data from your Zoho Creator account and links it to your Power BI
application.
 It enables you to pull in the data stored in Zoho Creator and create reports and resourceful insights in Power
BI.

 Marketo
 Marketo is a cloud lead management and marketing solution.
 Power BI Marketo Connectors such as CData can easily connect Microsoft teams Power BI with live Marketo
data for up-to-date visual analysis and reporting.
 The CData Marketo Connector is based on a highly-efficient query engine that has been optimized down to
the socket level with streaming and compression capabilities.
Questions

 Explain the different Types of Data Sources for Power BI Services

 Explain Different types of Power BI Connectors .
References

 https://www.biconnector.com/blog/what-are-microsoft-power-bi-
connectors/
 https://data-flair.training/blogs/data-sources-for-power-bi/