Mike Allen Systems
Power Apps Power BI Excel SharePoint
Power BI

Data Sources

Modern BI solutions can handle a vast array of data sources. This is a sample of what Power BI can process directly and they are available to other BI configurations as well
  • File

  • Excel
  • Text/CSV
  • XML
  • JSON
  • Folder
  • SharePoint Folder
  • Database

  • SQL Server
  • Access
  • Oracle
  • MySql
  • DB2
  • Sybase
  • Azure

  • CosmosDB
  • SQL Database
  • SQL Data Warehouse
  • Data Marketplace
  • Blob Storage
  • Table Storage
  • On-line Services

  • Google Analytics
  • Salesforce Objects
  • Facebook
  • Smartsheet
  • Dynamics 365
  • And many more...

Extract, Transform and Load (ETL)

Power BI and Excel have in-built ETL features; however for Enterprise solutions SQL Server Integration Services can be used to build and update a data warehouse