Connecting to data from different sources

Explore data, create relationships between them, analyze the key factors for your organization and make the right business decisions.

Data sources for Power BI

Power BI allows you to visualize and analyze data in an extremely simple and intuitive way, which is a key element in the process of creating interactive reports. The tool allows you to import data from hundreds of different sources and transform them into clear reports, giving you comprehensive and precise information that is an invaluable source of knowledge that is strategic for your business.

Power BI allows you to import Excel files, cvs files, as well as data from services such as Microsoft Dynamics, Google Analytics, Twilio, Marketeo and Salesforce. The tool also allows you to connect to cloud databases. Using direct queries, we can establish a dynamic connection to Azure SQL Database, Azure SQL Data Warehouse, Spark on Azure HDInsight and SQL Server Analysis Services. We can also connect directly to local SQL Server Analysis Services databases.

Data sources for Power BI

When making key decisions for your organization, you want to make sure your data is always up to date. The indicated data you import into Power BI can be downloaded and refreshed automatically, in real time, thanks to the Power Gatewa feature. You can also refresh the data manually or use the option to set up a refresh schedule so that your data is always the most up-to-date.
With email subscriptions and alerts in mobile apps for Android, iOS and Windows platforms, you will receive notification when changes occur to the data you specify.