Friday 5 January 2024

Name or list a few supported database sources for Power BI ? Power BI interview questions and answers 268

 Name or list a few supported database sources for Power BI ?

Here are some of the supported database sources for Power BI, divided into categories:


  • Relational Databases:

  • SQL Server

  • Azure SQL Database

  • Access

  • Oracle

  • IBM Db2

  • IBM Informix

  • IBM Netezza

  • MySQL

  • PostgreSQL

  • Sybase

  • Teradata


  • SAP Business Warehouse

  • Cloud-Based Data Warehouses:

  • Amazon Redshift

  • Google BigQuery

  • Snowflake

  • Azure Synapse Analytics

  • Multidimensional Databases:

  • SQL Server Analysis Services

  • Azure Analysis Services

Azure Data Sources:

  • Azure Storage:

  • Azure Blob Storage

  • Azure Table Storage

  • Azure Analytics Services:

  • Azure Data Lake Storage Gen1 and Gen2

  • Azure Data Explorer (Kusto)

  • Azure HDInsight (Hadoop, Spark)

  • Azure Cost Management

Other Data Sources:

  • Files: Excel, CSV, Text/JSON, XML, Folders

  • Web: Web Pages, APIs (REST, OData)

  • Other: Salesforce, SharePoint Lists, Spark, Databricks, Common Data Service (Microsoft Dataverse), Contoso Data Lake, Dynamics 365 (Finance and Operations), Dynamics 365 Business Central, GitHub, Google Analytics, Google Sheets, MailChimp, Marketo, Planview Enterprise One, Project Online, QuickBooks Online, Salesforce Marketing Cloud, ServiceNow, Smartsheet, SparkPost, Stripe, Twilio, Zendesk, 6 River Systems

Important Notes:

  • Connection Methods: Power BI supports two primary connection methods:

  • Import: Copies data into Power BI's internal storage.

  • DirectQuery: Queries data directly from the source when visualizations are used.

  • Gateways: For some on-premises data sources, a Power BI gateway may be required to securely connect.

  • Third-Party Connectors: The Power BI marketplace offers additional connectors for various data sources.

No comments:

Post a Comment

Note: only a member of this blog may post a comment.