Join Gini von Courter for an in-depth discussion in this video Overview of Power BI data sources, part of Power BI Pro Essential Training.
- [Voiceover] If we look at the entire set of tools for Power BI, we can connect to an absolute array of data sources, some of them on premises, some of them in the cloud. For example, for cloud data sources, you can quickly and easily connect to Software as a Service, or SaaS, solutions. Examples of this are connecting to your customer relationship management, or CRM data, whether it's kept in Sales Force or in Microsoft Dynamics CRM.
To connect to MailChimp to find out information about MailChimp campaigns. To be able to connect to QuickBooks Online and analyze information about your receivables or your payables, or your jobs and customers. Google Analytics, Sage, and there are new solutions being published almost weekly by Microsoft. Additionally, you can connect to Azure. For example, to your Azure SQL Server and analyze data that you have there.
If the information that you want to connect to doesn't already have a solution, then your IT folks can develop custom content packs for your organization, or even custom connections to specific types of data. On-premises, your choices include your SQL data, through SQL Analysis Services. So if you have data that you have in SQL Server in your organization, you can connect to it through Power BI.
You can also upload Excel workbooks, including Excel data models for use with Power BI Service, as well as comma separated values, or CSV, files. And files that you who have created in Power BI Desktop. Power BI Desktop and Power BI Desktop Pro can connect to additional data types that you cannot upload. For example, if I needed to connect to an Access database, and wanted to analyze that data, I can do that with Power BI Desktop or Power BI Desktop Pro.
In the next few movies though, we'll take a look at connecting to data using Power BI Service.
AuthorGini von Courter
- Signing up for Power BI Pro
- Connecting to data sources
- Uploading data such as CSV and XLS files
- Creating reports, visualizations, charts, and maps
- Filtering, sorting, copying, and pasting visualizations
- Downloading custom visuals from the gallery
- Modifying existing reports
- Creating and managing data dashboards
- Querying data with Power BI Q&A and Microsoft Cortana
- Sharing report and dashboards
- Using Power BI Desktop and mobile apps
Skill Level Intermediate
Learning Microsoft Business Intelligence Stackwith Ron Davis43m 35s Intermediate
1. Get Started with Power BI
2. Power BI Data Sources
3. Create a Report with Visualizations
4. Modify and Print a Report
5. Create a Dashboard
6. Ask Questions About Your Data
7. Share Data with Colleagues and Others
8. Use Power BI Desktop
9. Use Power BI Mobile Apps
Next steps1m 19s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.