Data Sources In Power BI Desktop

 Data Sources In Power BI Desktop


As we know that Powerbi support 99+ data sources, so in this article I have given overview of different data sources.
In Power BI Desktop we can connect to data from many different sources. By clicking on Home tab -> Get data , we can see different data sources.




The list of data sources is:
  • All
  • File
  • Database
  • Power Platform
  • Azure
  • Online Services
  • Other

File data sources

The File category provides the following data connections:

  • Excel
  • Text/CSV
  • XML
  • JSON
  • Folder
  • PDF
  • Parquet
  • SharePoint folder
The following image shows the Get Data window for File. By selecting required file type and clicking on connect option we can connect with respective file.




Database data sources

The Database category provides the following data connections:

  • SQL Server database
  • Access database
  • SQL Server Analysis Services database
  • Oracle database
  • IBM Db2 database
  • IBM Informix database (Beta)
  • IBM Netezza
  • MySQL database
  • PostgreSQL database
  • Sybase database
  • Teradata database
  • SAP HANA database
  • SAP Business Warehouse Application Server
  • SAP Business Warehouse Message Server
  • Amazon Redshift
  • Impala
  • Google Big Query
  • Vertica
  • Snowflake
  • Essbase
  • Actian (Beta)
  • AtScale cubes
  • BI Connector
  • Data Virtuality LDW
  • Denodo
  • Dremio
  • Exasol
  • Indexima
  • InterSystems IRIS (Beta)
  • Jethro (Beta)
  • Kyligence
  • Linkar PICK Style / MultiValue Databases (Beta)
  • MariaDB (Beta)
  • MarkLogic
  • Amazon Athena (Beta)
The following image shows the Get Data window for Database. By selecting required database type and clicking on connect option we can connect with respective database.


Power Platform data sources

The Power Platform category provides the following data connections:

  • Power BI datasets
  • Power BI dataflows
  • Common Data Service (Legacy)
  • Dataverse
  • Power Platform dataflows (Beta)

The following image shows the Get Data window for Power Platform. By selecting required power platform type and clicking on connect option we can connect with respective power platform.


Azure data sources

The Azure category provides the following data connections:

  • Azure SQL Database
  • Azure Synapse Analytics (SQL DW)
  • Azure Analysis Services database
  • Azure Database for PostgreSQL
  • Azure Blob Storage
  • Azure Table Storage
  • Azure Cosmos DB
  • Azure Data Explorer (Kusto)
  • Azure Data Lake Storage Gen2
  • Azure Data Lake Storage Gen1
  • Azure HDInsight (HDFS)
  • Azure HDInsight Spark
  • HDInsight Interactive Query
  • Azure Cost Management
  • Azure Databricks
  • Azure Time Series Insights (Beta)

The following image shows the Get Data window for Azure. By selecting required azure data source platform type and clicking on connect option we can connect with respective azure data source platform.


Online Services data sources

The Online Services category provides the following data connections:

  • SharePoint Online List
  • Microsoft Exchange Online
  • Dynamics 365 (online)
  • Dynamics NAV
  • Dynamics 365 Business Central
  • Dynamics 365 Business Central (on-premises)
  • Microsoft Azure Consumption Insights (Beta)
  • Azure DevOps (Boards only)
  • Azure DevOps Server (Boards only)
  • Salesforce Objects
  • Salesforce Reports
  • Google Analytics
  • Adobe Analytics
  • appFigures (Beta)
  • Data.World - Get Dataset (Beta)
  • GitHub (Beta)
  • LinkedIn Sales Navigator (Beta)
  • Marketo (Beta)
  • Mixpanel (Beta)
  • Planview Enterprise One - PRM (Beta)
  • QuickBooks Online (Beta)
  • Smartsheet
  • SparkPost (Beta)
  • SweetIQ (Beta)
  • Planview Enterprise One - CTM (Beta)
  • Twilio (Beta)
  • Zendesk (Beta)
  • Asana (Beta)
  • Assemble Views (Beta)
  • Automation Anywhere
  • Emigo Data Source
  • Entersoft Business Suite (Beta)
  • eWay-CRM (Beta)
  • FactSet Analytics
  • Palantir Foundry
  • Hexagon PPM Smart API
  • Industrial App Store
  • Intune Data Warehouse (Beta)
  • Projectplace for Power BI
  • Product Insights (beta)
  • Quick Base
  • SoftOne BI (beta)
  • Spigit (Beta)
  • TeamDesk (Beta)
  • Webtrends Analytics (Beta)
  • Witivio (Beta)
  • Workplace Analytics (Beta)
  • Zoho Creator (Beta)
  • Dynamics 365 Customer Insights (Beta)

The following image shows the Get Data window for Online Services. By selecting required online services data source platform type and clicking on connect option we can connect with respective online service data source platform.





Other data sources

The Other category provides the following data connections:

  • Web
  • SharePoint list
  • OData Feed
  • Active Directory
  • Microsoft Exchange
  • Hadoop File (HDFS)
  • Spark
  • Hive LLAP
  • R script
  • Python script
  • ODBC
  • OLE DB
  • Acterys : Model Automation & Planning (Beta)
  • Anaplan Connector v1.0 (Beta)
  • Solver
  • BQE Core (Beta)
  • Bloomberg Data and Analytics (Beta)
  • Cherwell (Beta)
  • Cognite Data Fusion
  • EQuIS (Beta)
  • FHIR
  • Information Grid (Beta)
  • Jamf Pro (Beta)
  • Kognitwin
  • MicroStrategy for Power BI
  • Paxata
  • QubolePresto (Beta)
  • Roamler (Beta)
  • Shortcuts Business Insights (Beta)
  • Siteimprove
  • Starburst Enterprise
  • SumTotal (Beta)
  • SurveyMonkey (Beta)
  • Microsoft Teams Personal Analytics (Beta)
  • Tenforce (Smart)List
  • TIBCO(R) Data Virtualization (Beta)
  • Vena (Beta)
  • Vessel Insight (Beta)
  • Zucchetti HR Infinity (Beta)
  • Blank Query

The following image shows the Get Data window for Other. By selecting required  data source platform type and clicking on connect option we can connect with respective data source platform.



Conclusion 


In this article different data sources of Power BI Desktop are explored including file data source, database data source, power platform data source, azure data source, online service data sources and many other.








Comments

Post a Comment

Popular posts from this blog

Use DAX iterator functions in Power BI Desktop models

Data Analysis Expressions (DAX) include a set of functions known as  iterator functions . Iterator functions enumerate all rows of a given table and evaluate a given expression for each row. They provide you with flexibility and control over how your model calculations will summarize data. Some DAX Functions are Complex summarization 1. SUMX e.g. : 1.  Revenue = SUMX (Sales, Sales[Sales Amount]) 2. Revenue = SUMX (Sales, Sales[Order Quantity] * Sales[Unit Price] * ( 1 - Sales[Unit Price Discount Pct.])) 3. Discount = SUMX ( Sales, Sales[Order Quantity] *( RELATED ('Product'[List Price]) - Sales[Unit Price] ) ) 2. AVERAGEX e.g :1. Revenue Avg = AVERAGEX ( Sales, Sales[Order Quantity] * Sales[Unit Price] * ( 1 - Sales[Unit Price Discount Pct.]) ) 2. Revenue Avg Order = AVERAGEX ( VALUES ('Sales Order'[Sales Order]), [Revenue] ) 3. RANKX The  RANKX  DAX function is a special iterator function you can use to calculate ranks. Its syntax is as follows: RANKX (<...
Read more

Different charts in Power BI

Image
  An overview of Chart Types in Power BI As everyone might be aware, Power BI is one of the SaaS offerings from Microsoft in the field of BI and Analytics. It provides a very intuitive way for non-technical users to do analyses and create reports on their own without having to rely on a technical team. One of the main purposes of Microsoft behind Power BI is to promote self-service BI and it is one of the BI tools in the market with a comparatively lower learning curve as there are many similarities compared to Microsoft Excel.  In this blog, I am going to give an overview of the most widely used chart types in Power BI.   Let's look at some of the most frequently used chart types in Power BI Bar and column charts Stacked Bar and Stacked Column Chart Clustered Bar and Clustered Column Chart Line Chart Area Chart Stacked Area Chart Line and Stacked Column Chart/ Combo Chart Line and Clustered Column Chart/ Combo Chart Ribbon Chart Waterfall Chart Funnel Chart Scatter Chart...
Read more

Modify DAX filter context in Power BI Desktop models

Summary CALCULATE  DAX function to modify filter context in the formulas. The syntax for the CALCULATE function is as follows: CALCULATE (<expression>, [[<filter1>], <filter2>]…) I learned about filter context. And also learned why and how to work with the CALCULATE function to modify filter context by passing in filters. These filters can add or overwrite the filter context, and they can modify filter context when we are passing in special functions like REMOVEFILTERS or KEEPFILTERS. Additionally, I learned that the CALCULATE function can transition row context to filter context, which can be required when we are using measure expressions in calculated columns or iterator functions.
Read more